Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default How do I create a chart on two axes with two lines and a bar

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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default How do I create a chart on two axes with two lines and a bar

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create chart with columns and 2 lines? Robert Charts and Charting in Excel 1 January 5th 06 04:10 PM
How do I create vertical lines in a line chart? jrmruz Charts and Charting in Excel 2 June 1st 05 02:41 PM
Missing lines in chart w/x-axis with months 1-24... DendWrite Charts and Charting in Excel 2 May 10th 05 09:04 PM
How to create a chart with Stacking colums and lines with 2 axes JGVOSS Charts and Charting in Excel 1 February 18th 05 12:19 AM
How to create chart with 1 column and 3 lines agenda9533 Charts and Charting in Excel 1 January 28th 05 02:12 PM


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"