Hi
I have been trying to highlight a series of cells & get Excel to draw a scatter diagram, where each point on the scatter ( i.e. a group of two numbers...eg 2, 9 ) can show the label name. I want every point in the scatter to have a unique name.
However Exel only allows me to show the series name against each point & not the unique name thats shown on the worksheet ( eg...London rainfall, or Manchester rainfall ).
I found that I can acheive this using a separate data-series for each 'point', but its a very manual solution, as its necessary to enter the three peices of data one by one. I cant find a way to simply highlight my data range & have excel assign cell A as the 'point name', cell B as the first data point & cell C as the second data point in a long series of similar cells.
Any thoughts ?
Bookmarks