Chart suppression of zero's

N

ncalpaperboy

HI, for a chart series of historical data that is not yet populated, I want
to suppress the chart plotting of zero's. The option of plot empty cells as
'not plottted' does not work. Thank you.
 
D

David Biddulph

Are the cells empty, or are they the result of a formula returning an empty
string ""? If the latter, replace the "" by NA().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unreadable text when viewing organization chart in Web version of Visio 365 0
Filtered view of Visio Chart 0
Create a chart from a table in word thats dynamic 0
Export BPMN Visio Chart to Excel 0
How to getting text labels to show up in scatter chart. 0
Non Linear Scatter plot, need to find y value 3
Chart not to pull Zero's 5
Employee Schedule not plotting properly - chart type / data series not correct 0

Top