current and future chart section in different colours

[mon]

Hi All Helpers, I have yearly charts set up for totals of
income etc (monthly and cumulative). How can I make the
chart a different colour after the current month?
Preferably also hiding the cumulative lines after the
current date.
Thanks
Mon

 

[Debra Dalgleish]

Jon Peltier has information on creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

that may help you.

 

[Tushar Mehta]

To end the cumulative graph with the current month, check the link
Debra provided or the Excel | Tutorials | Dynamic Charts page of my web
site.

To make the data for future months a different color, plot two
different series on the same chart, one for actual, the other for the
future data. Now, color each as desired. Basically, the data would be
laid out as:

Actual Project
Oct-03 1.1
Nov-03 1.2
Dec-03 1.3
Jan-04 0.8
Feb-04 0.7
Mar-04 0.8

and you'd plot 2 series, each based on columns.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions