Set a Min-Max for Axis on Charts
Options
Jason Maxwell
âśâś
I really like Dashboards and how it can visually tell where a project is at. What I do not like are the fluid charts. I would like to be able to set a Min-Max axis instead of having the axis change as items progress. Case in point with this script update - the min is 86% and the max is 102%. I want it to show from 0-100%.
Tags:
Comments
-
I am responsible for KPI reporting within my company. I have (as an example) two graphs of which one represents a KPI on a monthly bases (represented as bar graph) and the other dealing with exactly the same KPI but than filtered over several months (represented as a line graph). The vertical axis scaling in both cases is to be the same. The automated scaling that is provided by Smartsheet however does not provide this nor does it allow any customisation in the scaling.
My request is to allow for customisation of the axis ranges (in the example such that I could set the bottom graph vertical scale also to 120%).
-
The dashboard charts should be more configurable. Two examples:
- I have a bar chart tracking several series' progress to 100% completion, however the chart axis goes all the way to 120%, even when I toggle on "scale to data values". 120% isn't possible in this case, and it looks very unprofessional.
- When I click on a chart, it should not only take me to the source chart, but to the specific line item. Often times we want to examine data on a more granular level, but the widget behavior only allows us to transport the view to the massive data set it is pulled from, giving no guidance as to where the data point they wanted to examine is.
These charts and metrics should be much more customizable.
-
When creating graphs, it would be great to be able to customize the Y axis with the range and increments you want. Sometimes the range displays as 120% which often isn't appropriate for the graph being created. I also personally prefer to have all/most my graphs with the same range and increments.
-
I also landed here because I was confused by the fact that my chart showed a y-axis range of 0-7 even though my source data range is 0-6. When the chart displays a '7' it implies that a value of '7' is possible, but it's not. So it makes the chart seem inaccurate. I don't mind the chart including some additional margin just for the purpose of white space or padding at the top, but it shouldn't be labeled. It's adding a value to the chart that's not actually in the data, which feels a little presumptuous.
-
Until Smartsheet fixes this, my solution for clients is to set the font for the axis with the percentages to be white which removes it (Highlighted area below). Then I add the value label to the series with the percent I want to display. When I do this to show progress, I use a stacked chart to show the remaining percentage (= 1-percentage I want displayed) and do not label the second series. Below is an example of progress against deliverables for a project plan. You may need to use bar chart vs. column if you find the series label is too crowded.
If you want more info, find me on Linked In under Kristine Candela, and connect - I am happy to help!
-
Sort of, what you dont see is what you get :P
Smart thinking, thanks for this workaround!
Continuous Improvement Facilitator in HVAC industry
