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