View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default zero values in bar chart

As Andy said, however, I hope you are really asking about a line chart, not a
bar or column. If column or bar, what did you want - how do you want to plot
nothing and 0?
--
Cheers,
Shane Devenshire


"Andy Pope" wrote:

Hi,

You will not get a visual difference as both bars have no height.
If you display data labels, showing value, then zeros will display and
empty cells will not.

Cheers
Andy

Terye N wrote:
Is there a way to plot zero values differently than blank cells? Not all
providers participate every quarter. In that case it would be empty. Other
providers are performing at zero percent. Either way, that quarter shows
nothing. There are too many data points to show values on each bar.
Thanks for any suggestions you have!