Yes, if you are saying that there is one pont in each series, Excel will be
able to plot the points that way.

It may well be that it can't readily be forced into doing that in one go
from the Chart wizard (but Jon will know how if anyone does). If the wizard
starts with a different set of assumptions, you can subsequently change it
through the Series tab under the "Source Data" option, but (as you say) it
will take some time if you have to do it for each series individually.
--
David Biddulph

"Viv" wrote in message
...
Hi Jon,

The percentage figures are intended to be the x series and the £ values
the
y series. A, B, C and the headings of each series, so this should be
enough
data shouldn't it?

"Jon Peltier" wrote:

Each chart series needs X and Y values, and an XY (Scatter) chart uses
numerical data for each. You've only provided enough data for one series,
unless the A-B-C is intended to be used as the X values for two series,
in
which case you should use a line chart (the XY will replace text by
counting
numbers 1, 2, 3, etc.).

You will also need to take measures to show both percentages and
thousands
of pounds on the same chart, probably by plotting one of these on the
secondary axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Viv" wrote in message
...
Hi,

A colleague of mine is trying to set up a scatter graph with multiple
series
as follows:

A 10% £20,000
B 15% £15,000
C 12.5% £16,000
etc....

He wants the scatter graph to have a key for each series.

I can't find a way of doing this by selecting a data range. I've been
able
to do this by adding each series individually, but as there are a large
number of series this will take some time.

Has anyone got any suggestions? I hate it when Excel beats me!

Thanks
--
Viv