multi values in Y axis

  • Thread starter Thread starter Gil Sudai
  • Start date Start date
G

Gil Sudai

i need to do an Excel graph that combines two graphs.
for example, weight VS time, and height VS time.
the X axis is the same, the Y axis is from two sources.
is it possible?
 
Gil -

Make the chart with one set of X-Y data. You probably should make an XY
Scatter chart and not a Line chart. Copy the X-Y data for the second
series, select the chart, and from the Edit menu, choose Paste Special,
and add the data as a New Series, with Categories in First Column.
Double click on the ne series, click on the Axis tab, and select Secondary.

- Jon
 
Back
Top