color of last bar on bar chart

P

PBcorn

I have a dynamic rolling 13 month bar chart, but want to color the current
month (right-most bar) a different color to the other bars. Can this be done?
(needs to work as chart rolls forward each month).

Thanks
 
A

Andy Pope

Hi,

Simplest thing to do, without introducing VBA, is to use another dummy
series which only has data for the last point. You can set the Series
Option for Overlap to 100. This will place the columns/bars on top of
one another so the new series will obscure the main data series.

Cheers
Andy
 
P

Peter T

If by 'dynamic' you mean a dynamic range defines the series, unless I'm
missing something why not simply format the last point to a different
colour.

Regards,
Peter T
 
P

PBcorn

Yes this does what I need. For some reason I thought it might be a more
difficult problem!

thanks
 
A

Andy Pope

It would have been more difficult if your chart was not rolling.
Peter picked up on that point and suggested the more obvious solution :)

Cheers
Andy
 
Top