multi values in Y axis

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?
 
J

Jon Peltier

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
 

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

Top