chriswhincup
New Member
- Joined
- Apr 19, 2023
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Hi, I have a number of pivot tables that use my companies data but when I select years I can only get the dates to appear like this. I want them to be side by side but can't find an option to do it so i'm not sure if its a fault of the data or a setting. It makes my dashboard long and means when I try to create a chart the bars are not in the most visually pleasing way. I would love a way to be able to display the data with January to December down the 1st column and then the years in the next columns. If I add an additional year it simply puts another column in. This then also affects all my formatting.