Skip to Content
0
Former Member
Jan 11, 2011 at 08:29 PM

Exclude null y-axis value from bar chart?

331 Views

Short version: I have a bar chart. Is there a way I can hide a bar with a null y-axis label from the chart altogether?

Longer version: I have a subreport that is intended to show both the top and bottom 10 users based on some calculated average. However, if there are less than 20 users total, I want to split the users evenly between the two charts, to prevent the same user from showing up on both charts. I have been able to successfully do both of the following (assume 10 users total, so there should be 5 in each chart):

1) Get the "bottom N" chart to show the bottom 5 users, along with grouping all the rest of the users into a bar with a label of "" (if I could just hide this, I would be done).

2) Get the "bottom N" chart to show the bottom 5 users, and error out the summary for the rest of the users (using a null parameter), but this ends up showing a completely blank space where the bar would otherwise be. Which is odd, because I thought that erroring out a summary would cause it to be missing altogether.

I'm strapped for ideas, it seems quite frustrating considering how simple of a thing I want to do.