drop zero lines from charts
I have a automated chart I create every month. Sometimes there is no data for
that month. I'd like the chart to still show that month without the line
dropping to zero.
I have the data below the chart coming over as blank by formatting the cell
to "number" and setting it at "0;-0;;". I was hoping that there is an easy
way to have the line in the chart drop off also when there is no data to come
over.
Thanks in advance
--
Baltimore Ravens
|