Sign in to join the conversation:
Good Day
t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible?
regards
Hi Luis
I believe you have come across a limitation in charts, I don't think you can manually edit the vertical axis as this is a dynamic setting determined by your data.
If this were my issue, I would try a workaround, by adding a test column of data to my table, with data in it to force the Axis to increase to show the numbers I want. Then I would change the colour of that series to the same colour as the background of the chart to "hide" it. That way you get your axis updated dynamically, but there will be a "space" in the chart. I would make the test column the last column in the data table, that way it might not be so noticeable.
Hope this helps.
Kind regards
Debbie Sawyer Consultant & Training Manager
Smarter Processes mean happy people in successful businesses
I too am in need of the ability to have a set y-Axis. I often get, when there is no data or when data is actually a 0, a -1 and -2 below the zero line. The ability to fix the y-Axis to a desired # range should be a feature set in the Chart Widget. Please vote this up.
Jumping in here to post a link to the existing product idea: Set a Min-Max for Axis on Charts - please add your vote to this idea @VinceA! You’ll then receive updates when the status of the idea changes!
Thanks,
Georgie
I looking to find unique values, in order, and separate them into columns. The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula: =MIN([Client Update Date]:[Client Update Date]) In the "2nd Date…
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
I need a column formula that can add sequential, unique IDs to data like this coming in from a form: Task Type Task ID Manual M001 Automated Manual M002 Manual M003 Manual M004 Automated Manual M005 Task IDs that aren’t the manual type need sequential numbering within their type (i.e. A001, A002, etc). Here’s the kicker:…
