If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
current and future chart section in different colours
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 |
#2
|
|||
|
|||
current and future chart section in different colours
Jon Peltier has information on creating dynamic charts:
http://www.peltiertech.com/Excel/Charts/Dynamics.html that may help you. mon wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
current and future chart section in different colours
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 In article , says... 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 |
Thread Tools | |
Display Modes | |
|
|