2 sets of data I need one line

T

Tim

I have two sets of data, height and distance and I want both to be on the
same line and not two seperate lines. I would appreciate any help
Thanks
 
A

Andy Pope

Hi,

You need to create a xy scatter chart.
Assuming you have already tried selecting both ranges of data and
creating a chart try this instead. Select the y values and create a xy
scatter chart. Then right click chart and use the Source data dialog to
specify the x values.

Cheers
Andy
 

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

Two lines in one in one line - How to do 2
Line Numbers Will Not Show 0
Margin from bottom edge of a page to the last line of the last paragraph 1
Autonumber field in Excel that behaves the same as Access 0
How to set tabs in work document 0
Have 4 email addresses Want to auto forward all in one of them 0
Format column widths from one table to a separate table on same page 1
Space at end of multi page list to accommodate new entries 1

Top