Hide blank chart values...

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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)
 
Back
Top