Customizable Axis Values in Smartsheet Dashboard Graphs

Sean C.

It would be useful to have the ability to customize the horizontal and/or vertical axis values for graphs so that series of graphs can present data in line with each other. In our instance, we have created a dashboard containing all the members of our team and their projects. We have separate stacked bar graphs for each member to show the current projects they are working on and the time allocated for each project. We want a quick view to see who is over-allocated and who could take on more work. Having each team member's projects on separate graphs is useful as we can click the graphs to open their reports if we need more details on a specific project and track its progress.

Currently, the stacked bar graph defaults to a certain percent over the data in that graph: if John Smith's project equals 120%, the graph extends to 140%. If Alex Johnson's projects equal 90%, the graph extends to 100%. Without being able to set a fixed 140% baseline for each graph, all the team members' graphs look the same at a glance, which is very deceptive. In certain cases, a team member who is under-allocated can appear to have more work on their plate than someone who is over-allocated, as shown in the example screenshot.