How do I create a chart on two axes with two lines and a bar

How do I create a chart on two axes with two lines and a bar

Post by hmcelrat » Wed, 15 Feb 2006 01:45:23


I am trying to compare two final stock prices to the average volume.
So, teh left axes would have the numbers for the stock prices, and the
right axes would have the volume. The two stock prices would be lines
using the left, and the volume a bar using the right. I can do one line
and one bar, but I can't figure out two lines.

Can anyone help?
 
 
 

How do I create a chart on two axes with two lines and a bar

Post by Jon Peltie » Wed, 15 Feb 2006 11:15:03

Forget the built in custom types. It's better to build your own. Create your
chart using all the data, to produce a chart with three line series all on
the primary axis. Select the Volume series, and on the Chart menu, use Chart
Type to change it to a column type. Then double click on the Volume series,
and on the Axis tab, choose Secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://www.yqcomputer.com/
_______