| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel - Plot Coordinates in a graph
Is it possible to plot coordinates in a graph. If i have a column, for
instance, A with a value of 12 and a column, B, with a value of 8, then can I create a graph which will plot a point at 12,8? Please help! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel - Plot Coordinates in a graph
Hi,
Yes, use the chart type xy-scatter markers only. Cheers Andy McQuaid wrote: Is it possible to plot coordinates in a graph. If i have a column, for instance, A with a value of 12 and a column, B, with a value of 8, then can I create a graph which will plot a point at 12,8? Please help! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel - Plot Coordinates in a graph
Cheers, I do this but i keep getting 2 seperate points. Please see table
below. I have 2 criteria, influence and alignment. I want the point on the graph to be (13,11) but i get 2 dots when doing an xy scattergraph, one at 13 and one at 11. I've gone through and tried changing axis etc but can't get a single point instead of two. Influence Alignment Dr Who 13 11 Dr Spock 16 10 Dr No 17 7 "Andy Pope" wrote: Hi, Yes, use the chart type xy-scatter markers only. Cheers Andy McQuaid wrote: Is it possible to plot coordinates in a graph. If i have a column, for instance, A with a value of 12 and a column, B, with a value of 8, then can I create a graph which will plot a point at 12,8? Please help! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel - Plot Coordinates in a graph
If you select the column with names then yes you will get two series.
Just select the xy pair. To apply a textual data label use this free addin to link data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy McQuaid wrote: Cheers, I do this but i keep getting 2 seperate points. Please see table below. I have 2 criteria, influence and alignment. I want the point on the graph to be (13,11) but i get 2 dots when doing an xy scattergraph, one at 13 and one at 11. I've gone through and tried changing axis etc but can't get a single point instead of two. Influence Alignment Dr Who 13 11 Dr Spock 16 10 Dr No 17 7 "Andy Pope" wrote: Hi, Yes, use the chart type xy-scatter markers only. Cheers Andy McQuaid wrote: Is it possible to plot coordinates in a graph. If i have a column, for instance, A with a value of 12 and a column, B, with a value of 8, then can I create a graph which will plot a point at 12,8? Please help! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel - Plot Coordinates in a graph
Excellent, thank you so much!
Chris "Andy Pope" wrote: If you select the column with names then yes you will get two series. Just select the xy pair. To apply a textual data label use this free addin to link data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy McQuaid wrote: Cheers, I do this but i keep getting 2 seperate points. Please see table below. I have 2 criteria, influence and alignment. I want the point on the graph to be (13,11) but i get 2 dots when doing an xy scattergraph, one at 13 and one at 11. I've gone through and tried changing axis etc but can't get a single point instead of two. Influence Alignment Dr Who 13 11 Dr Spock 16 10 Dr No 17 7 "Andy Pope" wrote: Hi, Yes, use the chart type xy-scatter markers only. Cheers Andy McQuaid wrote: Is it possible to plot coordinates in a graph. If i have a column, for instance, A with a value of 12 and a column, B, with a value of 8, then can I create a graph which will plot a point at 12,8? Please help! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel graph problem | Excel Discussion (Misc queries) | |||
| Excel should let you graph every n-th data point in a column | Charts and Charting in Excel | |||
| Can I grab graph coordinates in Excel via the mouse with VB? | Charts and Charting in Excel | |||
| How do I plot non-numeric values in a graph in Excel? | Charts and Charting in Excel | |||
| Copying an Excel Graph to PowerPoint | Charts and Charting in Excel | |||
Linear Mode
