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

Hi,

Select the chart and choose Tools, Options, Chart, and select from the
options for "Plot empty cells as"
--
Cheers,
Shane Devenshire


"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!