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.

Welcome!

A few questions about new Charts function

Randy Van Winkle

Very pleased to see the new charts function in the dashboard section. A couple of questions have already come up for me.

Can the scale of the axis be manipulated? A chart that I added is demonstrating the % done of certain steps in an HR process. The scale of the Y axis is set at 200%
In a similar example, I tried to make a chart out of the % done from parent rows in a project sheet. I copied the parent cells into a contiguous chart in another sheet. When adding the data in the Edit Chart Widget, the display shows Invalid Data, To create a chart you must use numeric data. To confirm, these are live percentages that update with the data in the sheet and not alpha text

Any help appreciated

Find more posts tagged with

Comments

Sasan

Randy,

Thanks for your feedback. Here are answers to your questions:

1. The scale is auto generated. We will consider your suggestion in custom configuration in future versions.

2. On your second step in Edit Chart Widget, you may want to check your data selection. When the "invalid data" is presented, it's most likely due to the selection only having included labels/text. A screen capture of your range will also help us provide more assistance.

Sincerely,

Sasan

Randy Van Winkle

Here is the targeted information. The primary column and Column 2.

Capture 3.PNG

Sasan

Randy,

A picture is a 1000 words. In looking at your Column2 content formatting, I noticed that your %s are left justified. That was a clue, that your Column2 properties may be of Contact List, etc. At this time the chart widget only supports the following column types:

Text/Number (obviously numbers only)
Dropdown List (numbers only, excluding strings that look like numbers)
Auto-Number/System-generated column (numbers with no Prefix or Suffix)
Symbols (replaced with numbers)

The column property could be the cause. Let's try changing your Column2 properties to one of the above and try creating chart. Let us know if that works.

Thanks

Sasan

Randy,

We just updated the charts widget to reduce the excessive padding on scale for % data values. The padding is now optimized. Hope this helps. Thanks

Sasan

Sign in to join the conversation!

Quick Links

Trending discussions

Automation
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
New Dashboards
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
why does it not show the bars in timeline view like most gantt charts do?
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.