R
Reddo
Can you highlight an individual column in a Bar Chart?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy Pope
Hi,
Manually you can select the series and then select an individual
bar/column and format it.
To have it done automatically you can use an additional series based on
some formula to create a conditional chart.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
Cheers
Andy
Manually you can select the series and then select an individual
bar/column and format it.
To have it done automatically you can use an additional series based on
some formula to create a conditional chart.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
Cheers
Andy
D
Del Cotter
Can you highlight an individual column in a Bar Chart?
Shadowing would be difficult and non-productive. You can change the
colour of an individual column by hand.
Or you can automate it by creating a new series that is zero except for
the highlighted value, and have the original series be zero only for the
highlighted value. This produces the effect of automatic "conditional
formatting".
S
ShaneDevenshire
Hi,
In 2007 you can add the following new enhancements to a single column
1. Bevel, Glow, Soft Edges and many more Shadow options
2. In addition you have Material and Lighting options
3. you have Join, Cap options as well as compound line choices for the borders
4. And you can create your own multi-color gradients (seems pretty difficult
to me)
But all of this is mainly eye candy - which, although I think it's cute, may
or may not be relevant to other people's work.
In 2007 you can add the following new enhancements to a single column
1. Bevel, Glow, Soft Edges and many more Shadow options
2. In addition you have Material and Lighting options
3. you have Join, Cap options as well as compound line choices for the borders
4. And you can create your own multi-color gradients (seems pretty difficult
to me)
But all of this is mainly eye candy - which, although I think it's cute, may
or may not be relevant to other people's work.