Charts - 2 y scales
I need to do a monthly and year to date on one graph. Bar for monthly which goes as high as 60, but line for YTD which goes up to 500. Can this be done? Is it in the works to be done?
Answers
-
Hi @Lisa-B
Yes, you can have both in one graph, but with different values like this the Monthly one may be fairly hard to see - it will look very small compared.
The way I'd do this is have the totals in Sheet Summary fields in the sheet, using formulas for the calculations. Then you can create a Sheet Summary Report as the source for your chart.
Let me know if you need help building this out! If so, it would be useful to see screen captures but please block out sensitive data.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives