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  

Co-ordinates plotting on Graph //sk



 
 
Thread Tools Display Modes
  #1  
Old March 27th, 2009, 10:30 AM posted to microsoft.public.excel.charting
sansk_23
external usenet poster
 
Posts: 19
Default Co-ordinates plotting on Graph //sk

Hi !!

Just wanted to check as to how can i plot the below co-ordinates on X & Y
axis along with the name of the co-ordinates :

Products - A , B, C, D
Co-ordinates1 - 10, 20, 30, 40 (to be plotted on X-Axis)
Co-ordinates2 - 20, 30, 40, 50 (to be plotted on Y-Axis)


A (10, 20)
B (20, 30)
C (30, 40)
D (40, 50)

The graph should also display the Products & its resp co-ordinates.

Pls. help me with plotting this data on an excel chart / graph.
Rgds
Sansk_23
  #2  
Old March 27th, 2009, 12:10 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Co-ordinates plotting on Graph //sk

Put this data into three columns:

A (10, 20)
B (20, 30)
C (30, 40)
D (40, 50)

Select the second two columns (the X and Y values), and create an XY chart.
To apply the first column to the points as labels, you could add labels to
the chart using any of the default options, like series name, and then edit
each label. After editing the third or fourth label, this becomes rather
tedious, but you can use one of these fine free Excel utilities to do the
labeling for you:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

The best part, is that they can put a link from the label to the cells, so
that changing a cell (e.g., from A to Alpha) changes the label on the data
point.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"sansk_23" wrote in message
...
Hi !!

Just wanted to check as to how can i plot the below co-ordinates on X & Y
axis along with the name of the co-ordinates :

Products - A , B, C, D
Co-ordinates1 - 10, 20, 30, 40 (to be plotted on X-Axis)
Co-ordinates2 - 20, 30, 40, 50 (to be plotted on Y-Axis)


A (10, 20)
B (20, 30)
C (30, 40)
D (40, 50)

The graph should also display the Products & its resp co-ordinates.

Pls. help me with plotting this data on an excel chart / graph.
Rgds
Sansk_23



 




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


All times are GMT +1. The time now is 07:23 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.