only certain amount of data in chart

[doowop5000]

Hi all - I am doing a budget chart which will have the selected data of actual 2007, budget 2007, actual 2006 (each showing as a line). Is there an easy way so that only the YTD months show?? i.e. if it is July, the charts shows only Jan-Jul of all the data rather than Jan-Dec of budget & 06 actual, with 07 actual dropping off after July...

Thanks in advance for any help!!

doowop

[oldchippy]

Does this link help?

http://peltiertech.com/Excel/Charts/...umnChart1.html