rjbinney
Active Member
- Joined
- Dec 20, 2010
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
It gets more complicated, but for the sake of learning:
I was thinking that I could just do a table:
And then just put an "X" in the corresponding cell if they sold in that territory in that year. (It's pulling from another sheet).
Then I could do a column chart, grouped by year, with territories on the Y- axis:
Note I don't just want to stack, but I want to show gaps (for example, in Territory 1 in 2019, two salesmen were in there, while all four were mucking about in Territory 4).
I feel like this should be easy - but I just can't get it to work!
My brain has become a black hole of graphing knowledge lately. Any help would be helpful.
Thanks
ETA = The "more on that"? In 2018 there were seven territories, it went up to 13 in 2019 and 2020, and dropped down to eight every year since.
- I have three sales reps
- I have multiple territories
More on that in a second
I was thinking that I could just do a table:
Year | Territory | Salesman 1 | Salesman 2 | Salesman 3 | Salesman 4 |
Then I could do a column chart, grouped by year, with territories on the Y- axis:
Note I don't just want to stack, but I want to show gaps (for example, in Territory 1 in 2019, two salesmen were in there, while all four were mucking about in Territory 4).
I feel like this should be easy - but I just can't get it to work!
My brain has become a black hole of graphing knowledge lately. Any help would be helpful.
Thanks
ETA = The "more on that"? In 2018 there were seven territories, it went up to 13 in 2019 and 2020, and dropped down to eight every year since.