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
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
Hello, I am trying to use JOIN-COLLECT to populate a cell with a contact by pulling from another sheet. However, when I use this formula it populates the cell with the name of the contact as a text string, but does not populate the cell with the contact itself. Both the column of cells being populated and the column the…
Hello Community, I need to create a report that shows capacity by month. My sheet tracks resource allocation on projects with resource start and end dates. (We can't afford the Resource Management module so we're doing it in Core SS). I've been asked to do a "heat map" of sorts where each column is a month. For each row…
