Reply to thread

Message

[QUOTE="royojaqual, post: 2618430"]
I have a running workbook that has tons of information.  I have added a sum
page in order to have all the data summed up in one simple place.  I have
formulas that read back into the workbook to link to a cell.  Depending on
what moth it is, that cell could be empty as it is a yearly wookbook. For
example, if this is August, then there is information in the workbook up to
August, but none after.  With that said, the sum page has the #DIV/0! in the
cell which essentially equals zero.  I also have graphs that I have linked to
this sum page.  My problem is in order to keep the graphs up to date, I have
to physically go back to each graph and move the data range.  I do this
because if I select for example, January through December, the graph goes
along till I have no data and drops to zero in the line graphing.  How do I
prevent the graphs from using the zero(or the cell unless theres data there)
to graph with?

Any help would be appreciated.

Thank you.
[/QUOTE]

Verification