The charts you create in Excel will only be as good as the data you work with. A secondary axis works well in a chart that shows a combination of column and line charts.” – Create a combo chart with a secondary axis, thanks Microsoft. The scale of the secondary vertical axis shows the values for the associated data series. So what is a Combo Chart? “When the numbers in a chart you created vary widely from data series to data series, or when you have mixed types of data (for example, price and volume), you can plot one or more data series on a secondary vertical (value) axis. From now on I think we all should write Excel in capitals “EXCEL” as it truly deserves to be put on a pedestal. Wow! You thought Excel was all about formulas? Think again. Excel is one mean, powerful, mother of data and stuff. I’m specifically referring to Charts, Tours, Reports, Sparklines, Filters and don’t even get me started on PowerPivots. Every blog I’ve written I’ve had to go research first. I cannot believe there is so much I don’t know. I’ve always thought I’m “kinda ok” with Excel. #Office365Challenge – Combo Charts in Excel.
