Hide blank chart values...

G

Guest

I have a chart in a form. The table with the data contains blank values.
The chart shows those as zero. Is there any way to hide these blank values?
 
F

fredg

I have a chart in a form. The table with the data contains blank values.
The chart shows those as zero. Is there any way to hide these blank values?
Click to expand...

In Form Design View, select the chart for Editing.
Tools + Option + Chart
Select "Empty Cell plotted as"
Not Plotted (leave Gaps)
 

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

Hide null column values in chart legend 1
One extra x axis item that wont go away - can anyone help? 3
Pivot table view does not show series data with decimals? 0
Hiding 0 value data labels in chart 8
Hiding zeros in dynamic charts 3
Chart embedded in a form looks blank in print preview 2
Referencing Chart Data? 1
Skip the Zeros in a chart 4

Top