Microsoft Excel : Combining Chart Types, Adding a Second Axis
David
Often it is useful to create charts which compare different types of data. For example, you might want to compare share price with trading volume, or revenue with number of units sold, or poverty rate with unemployment and consumer confidence, or any number of other things.
To quickly and clearly display data of different types, it can be helpful to plot some data series either with different chart types, on different axes, or both. Let’s look at an example.
Suppose I work at a manufacturing company and I’d like to analyze the number of units we’ve sold over the last few months and the total dollars sold each month. I’m hoping to identify trouble spots, such as high unit sales but low dollar transaction amounts, which may indicate that the units are being discounted too deeply.
I could make two different charts – one plotting units sold by month, and one plotting transaction dollars by month. However, it will be challenging to analyze the two charts separately. I’d much rather create a chart like the one pictured below.
Microsoft Excel : Combining Chart Types, Adding a Second Axis
Posted on: Thursday, December 4, 2008 at 1:37 pm 
How To, Software. You can follow any responses to this entry through the RSS 2.0 feed.
Both comments and pings are currently closed.
Comments are closed.
