Chartings…removing zeros

Topic

New Reply

Each month I have to produce a chart of cases by department.
Some departments will not have a case each month…so there is a zero in the field.
Without selecting each data series every month…some will be adjancent while others will not because they are zero…
Is there a way to plot all data except zeros???

Reply | Quote

Replies

I am not sure of your setup, but if have an autofilter and filter out the zeroes, they will not be plotted. Charts only plot visible data.

Steve

Reply | Quote