nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Sign in to vote on this idea

Keep the bar color from the chart widget that is manually selected

mookev

Problem:

From the chart widget, the bar color is selected for each of the data series. For example, "deadline passed", "deadline today", "deadline in 2 weeks", "deadline more than 2 weeks", "no deadline" are set with different color.

When one of the bar of the series is not displayed on the chart as there is no data to display, the previously selected color of the bar gets lost.

When the series comes back as there is data to be displayed, the color of the bar is not the color that was selected before and is a random color that the system selects.

Therefore, some series shows duplicated color which degrades the legibility. With this problem, it is not possible to use the chart widget for professional use.

Solution:

update the system to keep the color of the series that are manually selected from the chart widget.

Impact:

More users will use the chart widget.

Find more posts tagged with

Dashboards

functionality

Idea Submitted

Project Management

Enhancement Request

bar chart

Comments

Paul Newcome

This has actually been an issue for a long time. I'm surprised this idea hasn't actually been submitted already.

In the meantime, if you are using a sheet to feed the chart, you can add 0.00001 to the end of your calculations so that they never actually drop to zero. Adjusting the shown decimals in the sheet will make it so that your series labels stay as whole numbers as well.