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

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

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


"PBcorn" wrote in message
...
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

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

thanks

"Peter T" wrote:

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


"PBcorn" wrote in message
...
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

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

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

thanks

"Peter T" wrote:


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


"PBcorn" wrote in message
...

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