color of last bar on bar chart

  • Thread starter Thread starter PBcorn
  • Start date Start date
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
 
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
 
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
 
Yes this does what I need. For some reason I thought it might be a more
difficult problem!

thanks
 
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
 
Back
Top