There are times when the bar chart series values vary drastically and the smaller series values are not clear to the user. To facilitate user control over the
maximum limit, we can use an Input Text box near the chart. The chart will take the maximum limit from the user input provided during run time, else it will
take the maximum value from the calculated maximum value in the series.
Please see the steps that can be followed to achieve this.
MAX(G18:G62) gives the maximum in the series and K18 is the length of the maximum value.
Logic:- If the user input is provided, then the maximum limit is the user input otherwise it is the maximum obtained as per the formula.
This way you get a bar chart with a User input box to the right that gives you the liberty to select the maximum value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |