J
j.rose
We have a data range per month with 5 possible values. When there are
non-zero results for all 5, the columns sit next to each other, which
is fine. However I'd like the columns to sit next to each other for
only the non-zero values, ie if there only two rows in my data range
that have non-zero values, there should be two columns on my chart next
to each other with no gaps between them. The range selection is as
follows: "=Sheet1!$A$61:$BD$66". In short, I'd like the column chart
to ignore the 0 values in the data range and not to plot them or leave
a space for them.
Hope you can help!
non-zero results for all 5, the columns sit next to each other, which
is fine. However I'd like the columns to sit next to each other for
only the non-zero values, ie if there only two rows in my data range
that have non-zero values, there should be two columns on my chart next
to each other with no gaps between them. The range selection is as
follows: "=Sheet1!$A$61:$BD$66". In short, I'd like the column chart
to ignore the 0 values in the data range and not to plot them or leave
a space for them.
Hope you can help!