Hello all -
I would really appreciate any help on my issue.
I have a long bar chart that shows approx. 250 people. It runs several screen lengths down but I have some slicers setup. However, when you delimit the data to far, the chart dynamically changes the size of the remaining peoples' bars, almost to the point where 1 person takes up an entire screen size.
The question(s) - is/are there any way(s) to use the slicer where it will leave the "deselected" people on the chart but remove any data from them?
And/Or - are there any ways to have the chart resize itself based on the number of people left on the chart after selecting various slicer options?
Thank you for any help you can provide!!
I would really appreciate any help on my issue.
I have a long bar chart that shows approx. 250 people. It runs several screen lengths down but I have some slicers setup. However, when you delimit the data to far, the chart dynamically changes the size of the remaining peoples' bars, almost to the point where 1 person takes up an entire screen size.
The question(s) - is/are there any way(s) to use the slicer where it will leave the "deselected" people on the chart but remove any data from them?
And/Or - are there any ways to have the chart resize itself based on the number of people left on the chart after selecting various slicer options?
Thank you for any help you can provide!!
