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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives