A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Plotting X and Y to a single point



 
 
Thread Tools Display Modes
  #1  
Old February 3rd, 2006, 09:38 PM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old February 4th, 2006, 12:08 AM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old February 4th, 2006, 09:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Single Data Point on a new Series bocjoel Charts and Charting 1 November 15th, 2005 05:31 PM
How do I open Power Point mail file if I do not have Power Point? BigRedDog General Discussion 1 September 7th, 2005 10:08 PM
auto run power point files badger man Powerpoint 3 January 24th, 2005 04:11 AM
Plotting every Xth point only JMcG Charts and Charting 8 August 31st, 2004 03:43 PM
Retaining Data Point Colors while Deleting a previously plotted Column? Ken Black Charts and Charting 4 October 17th, 2003 03:54 PM


All times are GMT +1. The time now is 01:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.