Two lines with a different x-series (please help)

H

Heath

I would greatly appriciate any help I could get on this

I am trying two plot two different lines on the same chart
line 1 Line 2
X axis Y axis X axis Y axi
0 1.32 0 1.3
8.83 21.22 12.5 23.5

I have no problem with the chart accepting the new Y values (as a different series) but as you probably know you can only have 1 catagory x label so my chart does not show the second line extending out to 12.5 it only extends to 8.83 on a different slope and stops. How do I get it to accept the addittional x value and still have to seperate lines? Thank yo
 
D

Debra Dalgleish

Select the data for the second line
Choose Edit>Copy
Select the chart
Choose Edit>Paste Special
Select 'New Series' and 'Categoreis(X Values) in first column'
Click OK
 

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