How can I hide points for future dates on a Year to Date chart?
 

I don't want future points to show because if there is no data, it either
goes to zero, or I can keep the point the same as the previous month.
Neither result is good for me.

Jon Peltier has info on his site about this he

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

"rlmills" wrote in message
...
I don't want future points to show because if there is no data, it either
goes to zero, or I can keep the point the same as the previous month.
Neither result is good for me.