current and future chart section in different colours

  • Thread starter Thread starter mon
  • Start date Start date
M

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