Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
mea
 
Posts: n/a
Default Plotting X and Y to a single point

I would like to create a graph where the x value and y value are plotted as a
single point on the graph (I have 10 points I want to graph and I keep
coming up with 20). Seems like a common thing to do, but I can't find it.
Thank you
--
mea
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton
 
Posts: n/a
Default Plotting X and Y to a single point

mea -

Arrange the data in ten adjacent rows in two adjacent columns with X values
in the left column and associated Y values in the right column. Select the
entire data range (20 cells). Click the Chart Wizard (or choose Insert |
Chart), and select the XY (Scatter) chart type.

- Mike
www.mikemiddleton.com

"mea" wrote in message
...
I would like to create a graph where the x value and y value are plotted as
a
single point on the graph (I have 10 points I want to graph and I keep
coming up with 20). Seems like a common thing to do, but I can't find it.
Thank you
--
mea



  #3   Report Post  
Posted to microsoft.public.excel.charting
B. R.Ramachandran
 
Posts: n/a
Default Plotting X and Y to a single point

Hi,

Are you by any chance choosing "Line Plot" for the Chart Type? You should
choose "XY (Scatter)".

Regards,
B. R. Ramachandran

"mea" wrote:

I would like to create a graph where the x value and y value are plotted as a
single point on the graph (I have 10 points I want to graph and I keep
coming up with 20). Seems like a common thing to do, but I can't find it.
Thank you
--
mea

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
plotting 2 variables as scatter and naming each point Jane Charts and Charting in Excel 1 June 22nd 05 03:55 PM
How to extend a single point into a line in a chart? sibimelvin Charts and Charting in Excel 1 June 22nd 05 03:52 PM
Error bars for a single data point not whole series Helen Charts and Charting in Excel 1 April 13th 05 06:21 PM
plotting a single line graph plotting graphg New Users to Excel 0 February 26th 05 10:21 PM


All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"