If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I make a graph ignore zero's in Excel 98
Hi,
I set up a chart that graphs changes in quantity over time. It's source data comes from multiple different places in my spreadsheet, so, to make it easy to graph, I use formulas to set it out nicely.. namely, two rows, the top with date and the bottom with quantity. Problem is, that everyday I have to copy the quantity grabbing formula over to the next column. If I leave the formula pre-copied right across, it skews my trend line and makes my graph look terrible because it dives down to zero. If I don't copy the formula, I miss the latest set of data. Essentially, I just want it to consider zero's as skipped values but I can't seem to make it happen. Any advice would be very much appreciated. Thanks |
#2
|
|||
|
|||
How do I make a graph ignore zero's in Excel 98
Have your formulas return #N/A instead of zero.
Jerry Tino wrote: Hi, I set up a chart that graphs changes in quantity over time. It's source data comes from multiple different places in my spreadsheet, so, to make it easy to graph, I use formulas to set it out nicely.. namely, two rows, the top with date and the bottom with quantity. Problem is, that everyday I have to copy the quantity grabbing formula over to the next column. If I leave the formula pre-copied right across, it skews my trend line and makes my graph look terrible because it dives down to zero. If I don't copy the formula, I miss the latest set of data. Essentially, I just want it to consider zero's as skipped values but I can't seem to make it happen. Any advice would be very much appreciated. Thanks |
Thread Tools | |
Display Modes | |
|
|