New Data Not Automatically Added to Charts

How do I (if possible) get my charts to automatically update with new information that's been added to the sheet?

I currently have a sheet that has a scoring system based on a 0-100 percentage. When I created the chart I selected all the columns I wanted and included all 5 line entries. It charts just the way I want it to, however when someone uses the web form to enter new data, that new data is excluded from the chart and I have to manually edit the chart and select the new data.

Is there an option for the charts to automatically include new lines of data and update? Or does this have to be done manually everytime?

Find more posts tagged with

Dashboards

Comments

Andrée Starå

Hi Shawn,

You'll have to include the whole column(s) with the data that you want in the chart.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Shawn R

I believe I am doing that. Here you can see I have the columns selected.

However when new lines of data are entered the chart does not change. When I go to edit data, it only includes the lines that were already present when the chart was created.

Is there a special way I need to select the columns?

EDIT: Screenshots uploaded. Apparently I cannot add them into the post itself

Shawn R

Not really sure why my responses on here are disappearing, perhaps its because I am trying to attach images. I'll do my best to explain whats happening.

I have a sheet that summarizes scores of different audits. What we are looking to do is create charts that give us an idea of how we are trending on the performance of the audits, so multiple line entries are needed in order to compare past to present data.

When I go to the sights page and click add widget, I add a chart. It then prompts me to select a sheet. So I select my summary sheet. Then it forces to to highlight a block of data to report on. I cannot just merely select columns. So I select all of the data.

Then when I edit the charts I click the select columns option and select the two columns I want to report on. At this point, everything is the way I want. However, when new entries are submitted to the sheet the chart excludes those entries and has the highlighted data that I originally selected.

What I am hoping to accomplish is to just select the columns I want to report on so when new data is submitted the chart can update.

Andrée Starå

Shawn,

If I'm not mistaken I think that you need to use a report to be able to select the columns. Another way to do it is to use cell linking or cross sheet formulas.

Best,

Andrée

Shawn R

Yup, that works. Thanks for the help!

Andrée Starå

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Mr
hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept…
Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…