Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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://PeltierTech.com/ _______ wrote in message ps.com... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create chart with columns and 2 lines? | Charts and Charting in Excel | |||
How do I create vertical lines in a line chart? | Charts and Charting in Excel | |||
Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
How to create a chart with Stacking colums and lines with 2 axes | Charts and Charting in Excel | |||
How to create chart with 1 column and 3 lines | Charts and Charting in Excel |