excel bar chart

[briancostea]

does anyone know how i can change the color of each bar in a stacked bar chart in excel?

 

[SkipVought]

Hi,

Select the portion of the bar -- Format/SelectedDataSeries -- Patterns Tab

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[briancostea]

that changes all the bars ... i want to change each individual bar in the chart to a different color.

 

[SkipVought]

You can celect only ONE point as well as do the same.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[SkipVought]

What is your objective?

I want to change the color of a point in my data series because...

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[briancostea]

thanks skip, that worked. i'm not sure why i need to change to change the color is important?

 

[SkipVought]

That is a very tedious way to change the color of a bar.

You can APPEAR to change the color of a bar, by having 2 or more series and changing the VALUES in the series like so...
[tt]
Red Blue
20 0
[/tt]
[tt]
Red Blue
0 20
[/tt]
when the value changes, the bar seems to change from Red to Blue.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}