Peltier Tech
@peltiertech.bsky.social
Microsoft MVP for Excel, expert in Excel charting and VBA, creator of the best Excel Charting Add-In.
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.
March 8, 2025 at 5:13 PM
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.
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.
January 23, 2025 at 8:02 PM
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.
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.
January 23, 2025 at 8:02 PM
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.
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).
January 23, 2025 at 8:02 PM
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).
Below the ants are some Excel4Macros.
January 20, 2025 at 10:20 PM
Below the ants are some Excel4Macros.