Formatting for a chart
 

I am trying to scatter plot the following data but want the headers A and B
to be all the same color on the chart. Need to know how to do this.
A A A B B B . . ..
First 2 4 7 9 6 8
Second 3 4 5 7 3 3
Third 4 1 2 5 7 8

The data series is much longer than this (just gave you an example) making
it improbably to go into the chart and readjust each plot. When i chart
this, each column has its own color, etc. I want a way to have all the "A"
as one color etc. Any ideas? Thanks

Woody -

Format one series. Select another and press the F4 key to repeat. Do this until all
series are formatted the same.

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

Woody13 wrote:

I am trying to scatter plot the following data but want the headers A and B
to be all the same color on the chart. Need to know how to do this.
A A A B B B . . ..
First 2 4 7 9 6 8
Second 3 4 5 7 3 3
Third 4 1 2 5 7 8

The data series is much longer than this (just gave you an example) making
it improbably to go into the chart and readjust each plot. When i chart
this, each column has its own color, etc. I want a way to have all the "A"
as one color etc. Any ideas? Thanks