I just used a Pivot Table unironically for the first time. There is no recovering from this.

Send help.

A month later: I'm trying to use a Pivot Table in exactly the same way, but I've completely forgotten how I did it. Part of me is proud of the fact that I'm not entirely on the dark side, yet, but part of me also misses and desires the dark goodness which is a properly pivoted table.


I'm happy to say that, after a few months living with the ailment, I have cured my PivotTable problem.

I wrote a PowerShell script that gathers the data I need, processes it in the way I want (pivots it, one could say), generates the GnuPlot script needed to create the chart I want, and finally generates the chart I need with GnuPlot.

I feel like a developer again.

As a bonus, it's also easier to use a colour-pallet suitable for people with a limited ability to distinguish between colours.

· · Web · 0 · 0 · 1
Sign in to participate in the conversation

The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!