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

PBcorn wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info