y Axis minimum 0, maximum Autorange

Brian Hammond
Brian Hammond Customer
Second Anniversary
edited September 2019 in Idea Exchange

In a Cartesian graph (such as bar or line graph), I would like to be able to set the minimum of the y Axis to be 0, and the maximum to be Autorange (so that the highest the Y axis goes will be slightly higher than the highest spot on a bar or line graph).

 

Currently this isn't an option. If I select Autorange, the minimum will be set to just below the smallest bar on a bar graph. So if I am comparing Bar A which is 1.2 million and Bar B which is 1.4 million, the minimum will probably be set at 1 million and it will be visually misleading. It will make it look like there is a massive difference between Bar A and Bar B. However, if the minimum were set at 0, we could see that there is a proportionally small difference between the two.

 

I'm told that I can set the minimum manually to 0, and set the maximum to what I want. However, this is also unsatisfactory. Let's suppose I set the minimum to 0 and the maximum to 1.5 million (just above the top of Bar B). That looks just fine. But then let's suppose that I do some Selecting/Filtering. Then instead of Bar A (1.2 million) and Bar B (1.4 million), Bar A is 1,200 and Bar B is 1,400. The problem is that the maximum of the Y axis is still 1.5 million. In this case, we can't even see the difference between A and B.

 

This should be an easy fix, because this can be done in Excel.

3
3 votes

Archived · Last Updated

Comments

  • Product Management Team
    Product Management Team Employee, Group Leader
    250 Likes 500 Comments First Anniversary Name Dropper

    Thank you for sharing your insightful suggestion with us, Brian. Your time and effort are genuinely valued. 

    While we're not proceeding with your idea at the moment, this decision is based on our updated product enhancement and idea lifecycle processes, introduced in 2023 (details in our Idea Exchange FAQs). 

    https://community.board.com/kb/articles/1095-idea-exchange-faqs

    Despite this, if you believe your idea still holds relevance, we invite you to resubmit it for review under the new guidelines. We're dedicated to offering the best user experience and prioritizing features and enhancements that significantly impact everyday usage of our software. 

    Your input is crucial to our community, and we sincerely appreciate your participation. Please keep those creative ideas and feedback coming – we always look forward to hearing from you. 

    Thank you again for your understanding and continued support.

    PS: Please do have a look at the Idea Exchange FAQs to know more:  https://community.board.com/kb/articles/1095-idea-exchange-faqs

Categories