how can I use different colours in excel scattergrams?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to compare results using data from different sources by using a
scattergram
(in excel). My current efforts result in a lot of black dots, is there a
method that I can use that will create a different colour to identify each
data source? I have thought about using acetate overlays from each source.
Can you think of an easier/better method?
 
John B said:
I want to compare results using data from different sources by using a
scattergram
(in excel). My current efforts result in a lot of black dots, is there a
method that I can use that will create a different colour to identify each
data source? I have thought about using acetate overlays from each
source.
Can you think of an easier/better method?
Click to expand...

Put each data source in a different data series?
 
John B said:
I want to compare results using data from different sources by using a
scattergram
(in excel). My current efforts result in a lot of black dots, is there a
method that I can use that will create a different colour to identify each
data source? I have thought about using acetate overlays from each source.
Can you think of an easier/better method?
Click to expand...
 
Thanks David, your answer was just what I was looking for. I might have got
there myself but I doubt I will be around that long!
Once again thanks.
 
David I'm new to this so if my thanks go astray I'd like to say it once again.
You've made an old man very happy.
Jb
 
Back
Top