-
Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
-
Selected Data Cannot be charted
It does not matter which data I select, I am getting the error of Selected data cannot be charted. I even tried reusing a report that is producing a chart on a different dashboard, but I am unable to create new charts in a dashboard. Anyone have any ideas as to why?
-
Editable AI Dashboard Widgets & Dynamic Data Sources
Problem: Current Limitations Locked Data Sources: Once an AI-generated chart is created on a dashboard, the underlying data source selection is locked. You cannot simply "Edit" the widget to add a new sheet. Inability to Scale: If a project expands (e.g., a new team sheet is created), the existing AI visual cannot be…
-
Stacked Bar Chart to display Count AND percentage?
I am tracking orders in 3 statuses (Expected —aka my grand total; Rcvd; and Completed). I have a stacked bar showing the count of each, and this is the ideal visual i'd like, but i was hoping to also reflect the % of completed against Rcvd and Expected, and the % of Rcvd against expected. Is this possible?
-
Dashboard Data Label Display Issues
Hello, I have a dashboard with some pie charts and when I look at the pie charts, they look like this: But when my coworker views the same pie chart it looks like this: Is there a way to get their pie chart to show up like it does with mine? I'm in the Early Adopter Program and they are not but considering the modern…
-
Waterfall charts
I was with a company that they used waterfall charts to explain any month-to-month or year-to-year changes, either actual in the past or projected into the future. These are really hard to build unless the app supports it as a native type.
-
Request for Dashboard Chart Widget to Support Multiple Groups in Report
Currently, chart widgets on dashboards that are sourced by a report with multiple groupings only display data for the first grouping. This request is to optimize the chart widget to support data from multiple groupings in a report. For example, in a chart widget, display how many hours are planned for each team member,…
-
Chart generated using AI "Analyze data" function won't display on dashboard - how to fix?
I have an sheet that lists all of the projects for our department and one of the fields is called "Roles Involved" - it is a Dropdown list where users can select multiple values but entry is restricted to the list values. Using the AI "Analyze data" function I created a bar chart that counts the number of projects for each…
-
Planned vs Actual Charts
Hi everyone! Looking for suggestions on how to show planned vs actual in chart format. In Excel, we can have a line that shows numbers or percentages for planned and another for actual and then put it into a chart which shows the planned line and then actuals in a bar graph. I've provided an example below. Looking to do…
-
Creating Line Chart Across Quarters
I’m trying to build a dashboard that shows a line chart of average quarterly survey scores for each recruiter. Here's what I want to achieve: Each line represents a recruiter. The X-axis shows quarters (e.g., Q1 2025, Q2 2025, etc.) The Y-axis shows the average survey score I want to visualize trends over time for each…
-
Stacked Bar Charts from Multiple Columns
I found another idea from about 2 years ago that hadn't been updated, so I figured I would ask if this is already on the radar/roadmap. I would like to have the ability to use a stacked bar chart on my dashboard to show projects by Department and by Status. Here's an example I mocked up in Excel to show kind of what I'm…
-
Text Values showing as zeros in Scatterplot
I have a sparse data set that I am trying to plot on a dashboard, and we were using a line graph, but because the data is so scattered it doesn't present well: If I hover over the graph you can see the missing data points: So I thought I would try a scatter plot, but when I do all the "zeros" show up: These data are…
-
Column and Line Graphs not displaying percentages
Hi, My graphs on my dashboard are not displaying percentages (rather decimal numbers) when hovered over. All the data is in percentage format, and it is desktop application. This has recently changed, as before they were properly displaying percentages. How can I change it back? If this is something the dev team is working…
-
Change the "Select Data Source" UI for Chart Widgets Back
The new UI for selecting the data source for a chart widget in a dashboard has increased clicks and made it more difficult at times to select the correct source. Seeing the sheet or report data displayed in the same window as the source selector similar to creating a cross sheet reference is much more user friendly.
-
How do I add colors to a custom chart series theme within the dashboard?
I was working on creating a custom theme, and when I did that it populated with several colors for chart series colors. I began removing them because they weren't the colors I wanted and I saw a "+" button to add colors I did want. Now it won't do anything when I try to click the plus sign to add a new color. I'm stuck…
-
New chart labels are tiny
Smartsheet intended to modernise the look of the charts but it makes ours illegible. The labels at the end of the lines used to be visible but now they are tiny so unless I make the chart twice as big for no reason, it's useless. It's part of a dashboard which is why I don't want to increase the size because then viewers…
-
How can I automate dashboard charts?
Hi everyone, I'm fairly new to Smartsheet and looking for some advice. I'm in the process of building a project portfolio dashboard and would like to automate a 'Workload Distribution' chart. Currently, I have to manually update a separate metric sheet that serves as the data source, however, with how frequently the data…
-
ICYMI: Dashboard Charts Are Getting a Glow Up!
We've recently announced the rollout of cleaner, sleeker charts following another recent update that lets you add AI-generated charts directly to your dashboards. Check out these updates in this short video! https://youtu.be/iMmVROMludA
-
NEW! Modern chart styling and readability enhancements
Hi Community! This update introduces a series of styling and readability improvements to the chart widget, offering a more modern and polished visual experience across your dashboard. Enhancements include better spacing, improved text overflow handling, refined display of negative values, custom series label size and more.…
-
Why is my line chart not plotting horizontally (flat) for the same value?
I have a line chart showing % change over months; for the same value, I have lines that are not displaying horizontally in the chart and are implying a slight increase/decrease has occurred. The percentages are a simple average of cells in a column. I've verified already that the cells contain the same whole #s (no decimal…