Stacked bar chart help
I am trying to create a stacked chart that shows the number of studies started per quarter using the baseline start column as a reference and sorted by the 5 existing categories as shown in image 1. Image 2 is an example of the data source I would be using. Is this possible, and if so could I please get some assistance. Thank you!
Answers
-
I would suggest using a second sheet. The quarters would be listed down the rows in one column and the categories would be their own columns.
Quarters……….Cat 1………..Cat 2……….Cat 3
Q1 24
Q2 24
Q3 24
Q4 24
Q1 25
You would then use a COUNTIFS with cross sheet references to count how many rows have the corresponding Category and Quarter.
=COUNTIFS({Source Sheet Category}, @cell = "Category 1", {Source Sheet Quarters}, @cell = Quarters@row)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives