graphing two variables on one chart

  • Thread starter Thread starter Guest
  • Start date Start date
Yes. Select the custom type "chart line - column on 2 axes" and right click
 
Select one of the series on the chart and under the axis tab select secondary.
 
Your question sounded more fundamental to me than getting a secondary Y
axis, more like getting another series into the chart. Here goes:

If the chart exists with one series, go to Source Data on the Chart
Menu, Series tab, click Add, then select the data for the second series.
Or copy the Y Value range in the sheet, select the chart, and paste. Or
use drag and drop.

If you haven't made the chart yet, select the range that includes both
series of data, then run the chart wizard.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd chart type needed 2
Co-ordinates plotting on Graph //sk 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Plot value at top of chart 1
A line chart 3
Combining a 2-D column graph and a 2-D line graph on the same char 3
Create a solution region on a chart 3
How to create a bubble chart with more than 2 variables 0

Back
Top