If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 sets of data I need one line
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 |
#2
|
|||
|
|||
2 sets of data I need one line
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 Tim wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Inserting a new line in spreadsheet | Rental Man | General Discussion | 2 | January 9th, 2006 04:55 PM |
Sort pages? | David | General Discussion | 15 | May 13th, 2005 11:33 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |