psycoperl
Active Member
- Joined
- Oct 23, 2007
- Messages
- 339
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
- Web
Dear Excel Experts --
I have a stacked bar chart that I am working with that is starting to out grow even 11x17 (Tabloid) paper sizes. I was trying to figure out how to have excel split it so that it would span multiple pages. Ideally I would like to have the data table on the chart also split. As you can see from the screenshot the page is already getting very crowded and we will be adding more rows all the time.
The TOT column in the data table as you can see in the screenshot is not even showing the full value (5 digits).
I am hoping that there is a way to accomplish this without having to create and manage sub charts.
I have a stacked bar chart that I am working with that is starting to out grow even 11x17 (Tabloid) paper sizes. I was trying to figure out how to have excel split it so that it would span multiple pages. Ideally I would like to have the data table on the chart also split. As you can see from the screenshot the page is already getting very crowded and we will be adding more rows all the time.
The TOT column in the data table as you can see in the screenshot is not even showing the full value (5 digits).
I am hoping that there is a way to accomplish this without having to create and manage sub charts.