Pages

Wednesday, April 04, 2012

How To... Display Two Measures in a Bar-Line Chart in Excel 2010

To mark the occasion of reaching 1,000 subscribers I have created a new video on "How To... Display Two Measures in a Bar-Line Chart in Excel 2010". This one is inspired by the blog post Bar-Line Graph from Sanjay Matange on the Graphically Speaking Blog from SAS Software. Sanjay's post describes how to write the code using SAS Software to display "two measures by one classifier using a Bar-Line graph, where the scale of the two measures is vastly different". It seemed like a very complicated way to draw a Bar-Line chart, so I thought I'd give it a go in Excel 2010. It turns out to be very easy to do - here's my 4 minute 54 seconds video showing you how: