| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I hide data labels that show a zero value on histograms?
Hi, I need to know how to hide data labels that show a zero value on histograms. On *line chart*, I've put "=NA()" instead of the zero returned by the formula, and it functions, but using the same technique *with histograms* I got "#N/A" displayed on the chart. The only way to avoid it, it seems to me, it's leaving the cells blank, but I need to keep formula inside. Any suggestions? Thanks in advance, Sara -- saretta75 ------------------------------------------------------------------------ saretta75's Profile: http://www.excelforum.com/member.php...o&userid=27008 View this thread: http://www.excelforum.com/showthread...hreadid=414322 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
| Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
| Fan charts | Charts and Charting in Excel | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) | |||
Threaded Mode
