color coding different data series

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adri S. - 14 Apr 2008 19:46 GMT

Hello! I have about 8 spreadsheets of data that I need to compile into one
chart. However, I need to be able to look at the chart and see which
spreadsheet a data point is from. Is there a quick way to color code a group
of data points from one spreadsheet? I know I could change the color
individually, but with over 50 data points, I'd rather not if I don't have
to! Thank you.

Reply to this Message

Risky Dave - 15 Apr 2008 12:55 GMT

Hi,

If I undserstand you correctly all you need to do is right click on one of
the data points and select Format Data Series. You can then set the colour,
line weight, pattern etc. as you want.
Repeat for all eight data series. I don't know if there is a limit to how
many differently formatted series you can have on one chart - I'm sure older
and wiser eads on this forum will be able to tell you.

ATB

Dave

> Hello! I have about 8 spreadsheets of data that I need to compile into one
> chart. However, I need to be able to look at the chart and see which
> spreadsheet a data point is from. Is there a quick way to color code a group
> of data points from one spreadsheet? I know I could change the color
> individually, but with over 50 data points, I'd rather not if I don't have
> to! Thank you.

Reply to this Message

Adri S. - 15 Apr 2008 15:11 GMT

I pasted all of the data from the various spreadsheets into one sheet, and
then I created the chart, so Excel isn't reading the data series as coming
from different sources. Are my hands tied with this method?

> Hi,
>
[quoted text clipped - 15 lines]
> > individually, but with over 50 data points, I'd rather not if I don't have
> > to! Thank you.

Reply to this Message

Risky Dave - 15 Apr 2008 16:00 GMT

This will depend on what sort of chart you are trying to create. If it is
something simple like a bar than you can define teh various bars separately
and tso format them separately. This probably applies to other chart types as
well, but I haven't tried with most of them.

Take a look at Jon Peltiers site, especially the combinatin charts:

http://peltiertech.com/Excel/Charts/ComboCharts.html

Dave

> I pasted all of the data from the various spreadsheets into one sheet, and
> then I created the chart, so Excel isn't reading the data series as coming
[quoted text clipped - 19 lines]
> > > individually, but with over 50 data points, I'd rather not if I don't have
> > > to! Thank you.

Reply to this Message

David Biddulph - 15 Apr 2008 16:08 GMT

So long as you've got different data series, it doesn't matter that they're
all from the same sheet.
If you added all the points to your chart as one series, then you'll need to
split them to 8 separate series.

Signature

David Biddulph

>I pasted all of the data from the various spreadsheets into one sheet, and
> then I created the chart, so Excel isn't reading the data series as coming
[quoted text clipped - 25 lines]
>> > have
>> > to! Thank you.

Reply to this Message

Adri S. - 15 Apr 2008 17:53 GMT

My chart is an XY chart. I think I am going to have to redo my data source so
that each group of data from a different source is read as a separate source.

> So long as you've got different data series, it doesn't matter that they're
> all from the same sheet.
[quoted text clipped - 29 lines]
> >> > have
> >> > to! Thank you.

Reply to this Message