| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problem with plot
I have a scatter chart with a single plot that gets its data from the formula
=E7/C7, which works great. But when C7 is blank or a zero, you get the #DIV/0! error. So I tried to clean it up and use =IF(C7=0,"0",E7/C7). But now it plots it as a 1 instead of a 0. When I revert back to the =E7/C7, it correctly plots it as a 0. Why would it plot it as a 1 when the false value makes it a zero? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| scatter plot problem | Charts and Charting in Excel | |||
| Scratter Plot Problem | Charts and Charting in Excel | |||
| how do I create a box-plot (or whisker plot ) graph? | Charts and Charting in Excel | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
| Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel | |||
Threaded Mode
