| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Really basic help with a graph
Right, all I want to do is plot some points in a graph. I have 2 categories, influence and importance. the x axis is influence, the y axis is importance. Lets say I want to plot a point in a chart to show that George Bush scores 10 on each scale, whereas David Beckham scores 4 for importance and 7 for influence (let's say). How can I make excel represent these as single points in a graph in a graph?!? -- clfpele ------------------------------------------------------------------------ clfpele's Profile: http://www.excelforum.com/member.php...o&userid=36807 View this thread: http://www.excelforum.com/showthread...hreadid=565173 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Really basic help with a graph
A B C
Person Influence Importance GW 10 10 Beckham 7 4 Under Series, Name=$A$2, X=$B$2, Y=$C$2 You'll have to do this for each series, but it'll get you started if nobody else has any ideas. "clfpele" wrote: Right, all I want to do is plot some points in a graph. I have 2 categories, influence and importance. the x axis is influence, the y axis is importance. Lets say I want to plot a point in a chart to show that George Bush scores 10 on each scale, whereas David Beckham scores 4 for importance and 7 for influence (let's say). How can I make excel represent these as single points in a graph in a graph?!? -- clfpele ------------------------------------------------------------------------ clfpele's Profile: http://www.excelforum.com/member.php...o&userid=36807 View this thread: http://www.excelforum.com/showthread...hreadid=565173 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Really basic help with a graph
Or with a list, columns A-C as Matt suggests, plot B and C as your X and Y,
then use one of these utilities to apply the labels in column A to the points you've just plotted: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "mattgoof2005" wrote in message ... A B C Person Influence Importance GW 10 10 Beckham 7 4 Under Series, Name=$A$2, X=$B$2, Y=$C$2 You'll have to do this for each series, but it'll get you started if nobody else has any ideas. "clfpele" wrote: Right, all I want to do is plot some points in a graph. I have 2 categories, influence and importance. the x axis is influence, the y axis is importance. Lets say I want to plot a point in a chart to show that George Bush scores 10 on each scale, whereas David Beckham scores 4 for importance and 7 for influence (let's say). How can I make excel represent these as single points in a graph in a graph?!? -- clfpele ------------------------------------------------------------------------ clfpele's Profile: http://www.excelforum.com/member.php...o&userid=36807 View this thread: http://www.excelforum.com/showthread...hreadid=565173 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| graph problem - urgent help needed. | Excel Discussion (Misc queries) | |||
| Bar graph and line graph overlayed | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
| Graph Axes | Excel Discussion (Misc queries) | |||
Hybrid Mode
