Looking to have a stacked collum chart showing difference in values
Hello,
I am looking to have a stacked column chart showing the change in two values over the course of past, present, and future dates. I'd like this graph to update with new dates automatically based on what is added in the tracker.
The stacked column chart should display the months of a year in the x axis and thee quantity of what I'm measuring in the Y axis.
Is this possible to automate and do with one or a small amount of functions? I'd prefer not to create a sheet summary function for every month.
Please let me know if there are any questions.
Answers
-
you can do this by adding 2 columns to your sheet,
The first column "Month" would be 1-12 as integers
the second column would be a =sumifs(columntoadd:columntoadd,date:date,month@row)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives