Formatting for a chart

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

Guest

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top