| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
zero values in charts-don't want to show as zero, but as blank
I am trying to create a chart from data that is in the form of a formula,
some of those cells have a formula that returns a blank cell, "". I want my line chart to stop if the cell is blank, instead it is showing as a zero value. Any ideas on how to do this. |
|
#2
|
|||
|
|||
|
I am not 100% positive this is your situation, but I believe I ran into the
same problem a few weeks back. On your spreadsheet got to Tools/Options, then on the View tab uncheck Zero values. "ML" wrote: I am trying to create a chart from data that is in the form of a formula, some of those cells have a formula that returns a blank cell, "". I want my line chart to stop if the cell is blank, instead it is showing as a zero value. Any ideas on how to do this. |
|
#3
|
|||
|
|||
|
Unfortunately, that is not the problem. When I create my chart it still is
showing those value as 0. "Scott@PRM" wrote: I am not 100% positive this is your situation, but I believe I ran into the same problem a few weeks back. On your spreadsheet got to Tools/Options, then on the View tab uncheck Zero values. "ML" wrote: I am trying to create a chart from data that is in the form of a formula, some of those cells have a formula that returns a blank cell, "". I want my line chart to stop if the cell is blank, instead it is showing as a zero value. Any ideas on how to do this. |
|
#4
|
|||
|
|||
|
Revise your formulas to return the #N/A error.
That error message is invisible to charts. =IF(A1+B1=0,#N/A,A1+B1) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "ML" wrote in message ... Unfortunately, that is not the problem. When I create my chart it still is showing those value as 0. "Scott@PRM" wrote: I am not 100% positive this is your situation, but I believe I ran into the same problem a few weeks back. On your spreadsheet got to Tools/Options, then on the View tab uncheck Zero values. "ML" wrote: I am trying to create a chart from data that is in the form of a formula, some of those cells have a formula that returns a blank cell, "". I want my line chart to stop if the cell is blank, instead it is showing as a zero value. Any ideas on how to do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
| How do I hide 0 values in line charts | Charts and Charting in Excel | |||
| Some charts don't show | Charts and Charting in Excel | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Linear Mode
