How To Make A Two-Sided Bar Chart [VIDEO]

December 11, 2012 by · 2 Comments

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 … #ooolalaaa 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. [...]

Filed Under: Excel · Tagged With: ,

How To Chart Data Sets With Long Labels [VIDEO]

December 10, 2012 by · Leave a Comment

An issue I see a LOT in data visualization is choosing the wrong chart for the job. Personally, I have a strong affinity for the [vertical] column chart because I can combine metrics that can’t usually be combined using combination charts. (I’ll do a video on how to create one of those soon.) However, column [...]

Filed Under: Excel · Tagged With: ,

Change Dashes To Zeros In Excel

November 23, 2012 by · Leave a Comment

I might be alone in this, but I hate seeing hyphens in lieu of 0′s in tables and charts. Here’s what it looks like:   To change these dashes to 0′s select either the column or axis and press Ctrl/Command-1 to open formatting options. The formula, if you will follows this structure: Positive; Negative; Zero; [...]

Filed Under: Excel · Tagged With: ,