close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()