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?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
PeltierTech.com/
_______
gt; wrote in message ps.com...
gt;I am trying to compare two final stock prices to the average volume.
gt; So, teh left axes would have the numbers for the stock prices, and the
gt; right axes would have the volume. The two stock prices would be lines
gt; using the left, and the volume a bar using the right. I can do one line
gt; and one bar, but I can't figure out two lines.
gt;
gt; Can anyone help?
gt;
- Nov 21 Wed 2007 20:40
How do I create a chart on two axes with two lines and a bar
close
全站熱搜
留言列表
發表留言