Charting data
I have a sheet with 3,000 rows representing different jobs and recording the profit per hour for each job. I have sorted the jobs into customer groups and want to prepare a line graph for each customer group as illustrated below. Is this possible?
Answers
-
The way I would do this is to create one Report per-Customer Name. Then select each individual Report as the source for each individual Chart Widget.
The Report will filter out the rows so it's only the relevant ones for each customer, and it will automatically add new rows as they're added to the source sheet.
Let me know if that makes sense or if you'd like to see some screen captures to illustrate how to do this!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!