|
how to ignore the null value in bar chart? |
Posted by ethen_jean on May-07-2015 12:48 |
|
if i value the data as Chart.NoValue,it shows a blank bar in a bar group as pic1 shows,and
it shows a full bar when i value the data as 0 refered pic2.
the first question is how can i just ignore the bar that has no data in bar chart?
the second question is how can i custom each xaxis label of each bar in bar group?
thanks!
|
Re: how to ignore the null value in bar chart? |
Posted by Peter Kwan on May-08-2015 00:25 |
|
Hi ethen_jean,
Would you mind to clarify what is "ignore the bar" mean? I am thinking, not plotting the bar
put leave a blank space is ignoring the bar. Do you mean you do not even want the blank
space?
It is not to clear to me what type of bar chart you are using. It seems to be something like
a "Multi-Bar Chart" (that is, there are multiple bars grouped at the same x-position)? If you
do not even want the "blank", does it mean that each group will have a different size (which
means the x-axis labels are not evenly spaced, some are closer together and some are
further apart)?
Regards
Peter Kwan |
|