| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Chart
Hi
I want to plot a chart but it not to show the values if the value of the formula is zero even though they are ranged. Is there anyway this can be done? Cheers Shona |
|
#2
|
|||
|
|||
|
Hi Shona,
Try using the NA() formula instead of zero or "" Cheers Andy SS wrote: Hi I want to plot a chart but it not to show the values if the value of the formula is zero even though they are ranged. Is there anyway this can be done? Cheers Shona -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing a Chart Directly?? | Charts and Charting in Excel | |||
| Chart formatting | Charts and Charting in Excel | |||
| Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel | |||
Linear Mode
