Charts in Grid
Hello,
Can I create a bar chart and embed into the Grid layout?
For example, I have a table in the Grid layout and I'd like to reflect the data visually in a bar chart. Hopefully, the bar chart can be updated if the data is also updated.
Thanks,
AE
Best Answer
-
Happy to help. 👍️
Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You can't embed an adjusting bar chart into a grid, but you can display the bar chart alongside of the grid on a Dashboard.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you Paul! One more question...Do you know if I can edit the Grid in the Dashboard and have the bar chart auto-update?
-
To do that, you would need to publish the sheet with the ability to edit. Then you would use the Published version of the URL in a Web Content Widget. This will allow you to edit the sheet on the dashboard right alongside the chart. You may need to refresh the dashboard/web browser page, but this will work for you.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
You are awesome! Thank you, Paul.
-
Happy to help. 👍️
Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Okay, I clicked on "Vote Up" and "insightful."
-
Paul,
I tried to embed a GRID into a Dashboard, but the layout is very funky --- the widget created a very narrow column of data that I cannot resize. Then, I read that I need to create a REPORT first if I want to show the data in Grid view. Is that correct? What's the difference between GRID and REPORT?
-
No. You do not need to create a report.
You first need to publish the sheet. When you publish the sheet, you are provided with a published URL. You would drop this URL into a Web Content Widget on the dashboard. This widget can be resized as needed. I do this very frequently with clients where a form is embedded using a Web Content Widget alongside of the sheet so they can view what they are entering and various charts that will update to show them the effect of their entries.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Got it. I'm working with Laura to get access to the Publish feature for my Enterprise Trial. Thank you again!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!