Groupings in a scattergraph

[Bee]

Hello,
Can anyone tell me if its possible for a scattergraph to display different
groupings of individuals (business units) in another colour. The business
unit is not currently linking into the chart, just the salary and the pay
band. All the dots on the scattergram are showing exactly the same so I'd
like to be able to display them differently for each business unit.
Thank you

 

[Jon Peltier]

Split the single XY series into multiple series, one for each business unit.
Then each series can be formatted differently. If you have pay band and
salary data in columns A and B, put the business unit in column C, sort by
column C, then create the chart using the data only for the rows for unit 1.
Select and copy the data in the rows corresponding to unit 2, select the
chart, and use Edit menu > Paste Special to add the series to the chart.
Repeat for the other units.

You could format the series one point at a time, but that's tedious.

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

 

[Bee]

Thanks very much Jon, that worked perfectly. Very clever. Cheers