As I promised in my last video, in this video I take the bar chart and transform it into a sexy, double-sided bar charta la …
I first tried one of these with Tori Cushing, when we were charting out tweets vs. Facebook likes for a client, and it was love at first sight.
It’s a great option when you have two values with long labels you want to chart out. Or if you just want to show off.
Although I captured the video while working on a Mac (because the video quality on the work PC I brought home was crapola), I provide instructions for each step for both Mac and PC. It’s seven minutes.
Final Cleanup Tip
I didn’t include this in the video because Excel for Mac makes this so ridiculously difficult. But if you have any hints of OCD, it might bug you that the legend has PA on the left, while it’s to the right on the chart. If you didn’t notice that, you’re probably hating me for pointing it out. And I’m good with that.
Fixing The Legend on a PC
To fix it on a PC is easy peezy. Just right-click on the legend, choose Select Data, select DA under Legend Entries (Series), and click the down-facing arrow. You’ll see the legend update immediately.
Annnd On A Mac (Lame Alert)
To fix it on a Mac, follow the steps in this two-minute video. (It may help decrypt the scary Data Source menu anyway.)
Download The Excel File
You can download the Excel doc I worked from, if you want to poke at it a bit and take a peek under the hood.