Stacked Bar Chart Labels Unable to Show Negative Values

Raquel

I reached out to Smartsheet support regarding a labeling issue I encountered. When displaying data in a stacked bar chart (example on right), data labels do not appear for negative values. I can only get the negative values to appear on a regular bar chart (example on left).

Per the support team, any combination of columns that contain a zero or negative number causes this behavior. There currently isn't a way to show negative values in Stacked Bar charts in Smartsheet.

I love Smartsheets but they need to improve their charting capabilities. The alternative is to create the graph in Excel and add it to the dashboard as an image, which defeats the purpose of an automated process.