Chart help

  • Thread starter Thread starter smonczka
  • Start date Start date
S

smonczka

I have a chart that shows sales data for each company that has done
work for us by month for the past year. Problem is that if there were
no sales for that company for a given month, that month dosn't show in
the graph. What I need to show is a graph by company for every month
with a 0 sales total for that month if there were no sales.

I know I could just go through and put in a zero sale for each company
for any month that they did not have a sale, but...

I seem to remember that there is a setting that will do this for me.
Can someone tell me if I am corect and where this setting is?

Thanks
Steve
 
Select the chart
Choose Tools>Options
On the Chart tab, for 'Plot Empty Cells as', choose Zero.
Click OK
 
Back
Top