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" <John (E-Mail Removed)> wrote in message
news:9214CEAB-BE89-4B51-B5CC-(E-Mail Removed)...
>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?

Put each data source in a different data series?
--
David Biddulph

"John B" wrote:

> 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?

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.

"John B" wrote:

> 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?

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

"David Biddulph" wrote:

> "John B" <John (E-Mail Removed)> wrote in message
> news:9214CEAB-BE89-4B51-B5CC-(E-Mail Removed)...
> >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?
>
> Put each data source in a different data series?
> --
> David Biddulph
>
>
>