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.
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.
-
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.
-
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.
-
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.
-
Got it. I'm working with Laura to get access to the Publish feature for my Enterprise Trial. Thank you again!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 75 Community Job Board
- 502 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!