Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

chart showing future months data.

Posted by Mitul Rao on June 25, 2001 3:05 PM

The charts are showing value for future months on a line-graph. How can I have future numbers not show up. I tried to clear the cells it looks good and at the same time it deletes the formulas for the cells.
I need the formulas because they get the numbers from different sheets. The future numbers come up as zeros.
What will be the work around to get the solution.
Mitul

Re: chart showing future months data.

Posted by IML on June 25, 2001 3:24 PM

Can you get away with just hiding the columns of the future months? If not, a dymanic range may be order. If that is the case, I will gladly defer to someone else to provide that answer. (maybe I'll actually learn it for myself this time.)

good luck

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.