Hi guys. HELP!
I'm trying to make this into a stacked clustered chart to keep track of my employees' production. They essentially produce A and B types of reports, and I want to stack them and compare the production of each daily.
My challenge is that I can't display both employees' data under the same date unless I use two vertical axes, and that's not what I want, as I would have to fix the scale of both sides to keep them proportional.
Is there a way to do it using only the Left Axis? The TOTAL columns are not needed since the stacking will provide me the total
I'm trying to make this into a stacked clustered chart to keep track of my employees' production. They essentially produce A and B types of reports, and I want to stack them and compare the production of each daily.
My challenge is that I can't display both employees' data under the same date unless I use two vertical axes, and that's not what I want, as I would have to fix the scale of both sides to keep them proportional.
Is there a way to do it using only the Left Axis? The TOTAL columns are not needed since the stacking will provide me the total
| Book1.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | DATE | Mike A | Mike B | Mike Total | Nicky A | Nicky B | Nicky Total | ||
| 2 | 9-Jul-24 | 5 | 10 | 15 | 9 | 3 | 12 | ||
| 3 | 10-Jul-24 | 15 | 1 | 16 | 13 | 5 | 18 | ||
| 4 | 11-Jul-24 | 10 | 9 | 19 | 18 | 15 | 33 | ||
| 5 | 12-Jul-24 | 24 | 58 | 82 | 7 | 65 | 72 | ||
| 6 | 15-Jul-24 | 0 | 0 | ||||||
Sheet1 | |||||||||
