If you plot two different series on the same chart, the result won’t look good if the two series use wildly different data ranges. A good example is a stock chart that includes one series for closing prices and another series for volume. The prices might be measured in tens of dollars, whereas the volumes might be measured in tens of thousands of units. How can you combine these two disparate data sources so that you can see both series properly?
The trick here is to add another vertical axis-called the secondary axis-and tell Excel to plot one of the series using that axis. Here are the steps to follow:
- Click the chart to select it.
- Click the data series that you want to plot on the secondary axis.
- Choose Layout, Format Selection to display the Format Data Series dialog box.
- In the Series Options tab, click the Secondary Axis option.
- Click Close.
Figure 1 shows an example chart with two vertical axes-the primary axis (on the left) plots the Close series, and the secondary axis (on the right) plots the Volume series.
Figure 1 If you have series with wildly different data valÂues, plot one of them on the secondary axis.
Technorati Tags: dispaly second vertical axis
Popularity: 9% [?]
November 29th, 2009 at 2:44 am
To further improve this the trick is to indicate which data series goes with each vertical axis. one idea from another site is to label them, such as one as “volume (bars)” what I’m looking for is a way to split the legend so you can put some near the right axis, and some near the left axis. Or, color code them somehow. I have 8 series in my graph – 4 in quantity, and 4 in milliseconds. any ideas?
(BTW coffee needs 2 “f”s.)