| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Changing Colors in a Bar Chart
Hi guys,
I have a bar chart that has 3 bars in a chart. I am using a 2D Clustered Column. I need for each bar to have a seperate color. Name FSR QC CQA Leola 2 8 0 The color for the three? Using Late Binding, as I can't use Early Binding since others are using different versions of Excel (2002 and 2003). Select Case .ActiveCell.Value Case "QC" .Sheets("Chart1").Select .ActiveChart.SeriesCollection(x).Select .Selection.Interior.ColorIndex = 19 Case "FSR" .Sheets("Chart1").Select .ActiveChart.SeriesCollection(x).Select .Selection.Interior.ColorIndex = 18 Case "CQA" .Sheets("Chart1").Select .ActiveChart.SeriesCollection(x).Select .Selection.Interior.ColorIndex = 17 Case Else 'Do nothing End Select Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing colors of slices in a pie chart | Charts and Charting in Excel | |||
| changing colors | Excel Discussion (Misc queries) | |||
| pivot chart colors- how to keep from changing when data elements are added/removed? | Charts and Charting in Excel | |||
| HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS? | Charts and Charting in Excel | |||
| How do i stop the colors changing on my pivot chart when i refres. | Excel Discussion (Misc queries) | |||
Threaded Mode
