Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart formatting | Charts and Charting in Excel | |||
pivot chart formatting | Charts and Charting in Excel | |||
Problem with Chart Title Formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |