Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zero Values in Chart
Can anyone please tell me how to stop a chart from displaying zero values.
EX: 10 x axis entries but only the first 5 contain non-zero values. Thanks in advance.... Russ |
#2
|
|||
|
|||
If the cells are truly blanks, try Tools menu Options Chart tab
Show blank cells as... Not Plotted. If the cells only look like blanks, such as formulas that return "", change the "" to NA(): =IF(A10,A1,NA()) The NA() produces an ugly #N/A error in the sheet, but in line and scatter charts they aren't plotted. Debra Dalgleish shows how to hide the errors with conditional formatting: http://contextures.com/xlCondFormat03.html#Errors - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RUSS wrote: Can anyone please tell me how to stop a chart from displaying zero values. EX: 10 x axis entries but only the first 5 contain non-zero values. Thanks in advance.... Russ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
How to omit data in a chart when there are error values? | Charts and Charting in Excel | |||
Chart -- How to chart 65536 values in 1 series? | About this forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) |