want to draw a scattergram where each country dii colour (10 coun.

[ann]

i have 10 countries each with 5 cats, want to draw a scattergram where each
country is the the same colour and each cat within the country is the same
symbol

any suggestions

 

[Jon Peltier]

Ann -

Is there one point for each cat/country combination? A 50-series chart would do
that. I'm don't know what you're plotting in the chart, what are your X and Y
values. I have another idea, but it gets set up differently depending on the chart
arrangement.

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