G
girth69
I have a pivot chart set up that reflects data across an annual perio
with each plot point being a month of the year - jan - december.
The problem i have is that the line chart that i have in place has a
inclining slope showing the increase in the data as the yea
progresses. But as i only have data up until April, the line goes bac
down to zero for may. How can i get it to ignore the zero value that i
in my data series?? I cant just delete the formula in place as the
other parts of my spreadsheet wont work. Is there any way i can jus
have the line reflect the data that has values to it??
I can do it on a set of data where the value just reflects zero, but
think that because i have a formula in place for the data that at th
moment returns a zero value that it automatically picks it up??
please somebody help
with each plot point being a month of the year - jan - december.
The problem i have is that the line chart that i have in place has a
inclining slope showing the increase in the data as the yea
progresses. But as i only have data up until April, the line goes bac
down to zero for may. How can i get it to ignore the zero value that i
in my data series?? I cant just delete the formula in place as the
other parts of my spreadsheet wont work. Is there any way i can jus
have the line reflect the data that has values to it??
I can do it on a set of data where the value just reflects zero, but
think that because i have a formula in place for the data that at th
moment returns a zero value that it automatically picks it up??
please somebody help