Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Not using zeros in graphing.
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
replacing only zeros | New Users to Excel | |||
Graphing Woze? | Excel Discussion (Misc queries) |