iiinova — where your digital self keeps evolving

Peltier Tech

@peltiertech.bsky.social

Microsoft MVP for Excel, expert in Excel charting and VBA, creator of the best Excel Charting Add-In.

Peltier Tech @peltiertech.bsky.social · 08/03/2025

As an undergrad I lived 1/4 mile from the Mass Ave/Mem Drive intersection, and you could sometimes hear when a truck didn't make it. We'd go running out to investigate.

040

Reposted by Peltier Tech

Andy Woodruff @awoodruff.bsky.social · 27/02/2025

I finally have the chance to make a bunch of Boston maps again, and no collection would be complete without a map of Storrowing. (Truck vs low overpass) The “winner” of the last decade is not on Storrow, but rather adjacent to the smartest humans on the planet over at Mem Drive/Mass Ave.

Map showing locations of vehicles striking overhead bridge structures on Storrow Drive/Soldiers Field Road and Memorial Drive in Boston and Cambridge, Massachusetts.

3349

Peltier Tech @peltiertech.bsky.social · 10/02/2025

Better Pie Chart Data Labels peltiertech.com/better-pie-c...

peltiertech.com

Better Pie Chart Data Labels - Peltier Tech

How to improve pie chart data labels. Format with a glow effect, and use VBA to position between Center and Inside End. Also, how to fix VBA timing issues.

010

Peltier Tech @peltiertech.bsky.social · 10/02/2025

Better Pie Chart Data Labels I've just posted a tutorial showing how to improve pie chart data labels. First, format text with a glow effect to improve contrast. Second, use VBA to position labels between Center and Inside End. Also, you'll read how to fix VBA timing issues.

141

Peltier Tech @peltiertech.bsky.social · 28/01/2025

If You Don’t Need/Want Copilot... www.youtube.com/watch?v=eYVP...

youtube.com

Microsoft’s Sneaky Forced-Upsell to 365 Users; If You Don’t Need/Want Copilot, Don’t Pay for It

YouTube video by Atomic Shrimp

011

Peltier Tech @peltiertech.bsky.social · 23/01/2025

Gantt Chart with Nice Date Axis peltiertech.com/gantt-chart-...

peltiertech.com

Gantt Chart with Nice Date Axis - Peltier Tech

This tutorial shows how to create a Gantt Chart in Excel that has a nice date axis scale, with labels and gridlines at the start of each month.

020

Peltier Tech @peltiertech.bsky.social · 23/01/2025

But I'm the king of workarounds, especially when it comes to Excel charts. I've figured out a way, and I've updated the tutorial.

100

Peltier Tech @peltiertech.bsky.social · 23/01/2025

I've updated the technique to add milestones in the chart. Normally this would use a single-point XY scatter chart series, but the trick I used to get the nice date axis (spoiler: a secondary axis line chart series) prevented the use and added XY series.

100

Peltier Tech @peltiertech.bsky.social · 23/01/2025

Go ahead, count the pixels in the chart image: 1 Feb is closer to 1 Mar (28 days) than it is to 1 Jan (31 days).

100

Peltier Tech @peltiertech.bsky.social · 23/01/2025

A few years ago I wrote a tutorial showing how to make a Gantt chart with a "nice" horizontal date axis. This axis has proportionally spaced dates, e.g., the first of each month, which is not possible with a standard stacked bar chart construction.

Excel Gantt Chart with Nice Date Axis and Milestone

110

Peltier Tech @peltiertech.bsky.social · 22/01/2025

😊

000

Peltier Tech @peltiertech.bsky.social · 20/01/2025

Below the ants are some Excel4Macros.

010

Peltier Tech @peltiertech.bsky.social · 20/01/2025

Nice Bar Chart Data Labels This quick tutorial shows how to create data labels for your bar chart which are attractive, informative, and legible. #excelcharts #peltiertech peltiertech.com/nice-bar-cha...

peltiertech.com

Nice Bar Chart Data Labels - Peltier Tech

This quick tutorial shows how to create data labels for your bar chart which are attractive, informative, and legible.

041