View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Shadow or Highlight Column in Bar Chart

On Tue, 30 Sep 2008, in microsoft.public.excel.charting,
Reddo said:

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".

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.