chummychap
New Member
- Joined
- Nov 8, 2018
- Messages
- 2
Hi Excel Gurus,
After a week of googling, reading and trying. I am giving up to ask the experienced members of the community to please help me out.
I am using a pivot chart slicers with dynamic charts with multiple outputs.
1. How do I force the vertical value axis to be the same for each output. In this example company B is the odd one out hence cannot be compared visually. This is currently set to automatic, I cannot edit/ hardcode the vertical axis because it will affect other outputs in the slicer as the ranges widely differ.
2. How do I force slicer buttons to appear in a constant position without VBA? While this shows in the slicer, once clicked the button order moves about. I understand that I can use custom lists (File>Options>Advanced>Edit custom lists) but when the file is shared it does not work for others. I read somewhere it can be hardcoded using hierarchy but I can't figure out how to do this.
e.g
Employees
Salary
Hours worked
Many thanks for your time.
After a week of googling, reading and trying. I am giving up to ask the experienced members of the community to please help me out.
I am using a pivot chart slicers with dynamic charts with multiple outputs.
1. How do I force the vertical value axis to be the same for each output. In this example company B is the odd one out hence cannot be compared visually. This is currently set to automatic, I cannot edit/ hardcode the vertical axis because it will affect other outputs in the slicer as the ranges widely differ.
Year | Company A | Company B | Company C |
| 2019 | 118 | 78 | 192 |
| 2020 | 74 | 57 | 103 |
2. How do I force slicer buttons to appear in a constant position without VBA? While this shows in the slicer, once clicked the button order moves about. I understand that I can use custom lists (File>Options>Advanced>Edit custom lists) but when the file is shared it does not work for others. I read somewhere it can be hardcoded using hierarchy but I can't figure out how to do this.
e.g
Employees
Salary
Hours worked
Many thanks for your time.
