| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted Series Values on Line Graph
Hi there
I have created a line graph using cells with formulas in them however some of the formulas return #DIV/0! so I used an IF formula to get rid of these. However it doesn't matter if I ask the IF formula to display the result as a "" or 0 (or anything else for that matter) instead of #DIV/0! as on the graph the result ends up as showing a value at the bottom of the graph. If I have a few of these I just end up with a long line at the bottom of the graph until I get proper values and it shoots up! Apart from deleting the data / formula from the cells so no value shows, does anyone know how to stop this from happening? thank you -- James. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I specify X,Y axis and Series values in a line graph? | Charts and Charting in Excel | |||
| Line Graph: Differences between series | Charts and Charting in Excel | |||
| Add series to line graph | Charts and Charting in Excel | |||
| How do I add one line series to a bar graph? | Charts and Charting in Excel | |||
| Unwanted zero values in a graph | Excel Discussion (Misc queries) | |||
Threaded Mode
