Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ignore zero values when plotting a graph | Charts and Charting in Excel | |||
Excel should have semi-log graph plotting | Charts and Charting in Excel | |||
Plotting a Graph | Excel Discussion (Misc queries) | |||
Plotting graph directly onto the cells | Excel Discussion (Misc queries) | |||
plotting a single line graph | New Users to Excel |