I downloaded what I believe to be a MS Excel project timeline template (.xlsx). There's a table at the bottom and a corresponding (reactive) timeline with milestones above that is populated by inserted table date, title, width information.

All was proceeding swimmingly until I added a goodly number of table data points (lines). When I scrolled up to the timeline image after a while, it was 'scrunched' to fit 1 page wide. I've never run into a situation like this. I've always had to involve page break preview and page setup to control the 'normal' expansion of sheets both across and down.

There must? be 'something' in this sheet that's restricting the timeline to 1 page. I need to release that restriction but have no clue where to look?

[Start edit] I forced the page layout to 100%. No change in the page break preview--still 1 page. I then clicked on the chart image of the timeline, grabbed the lower right corner and expanded the chart to where the text was no longer scrunched and was clearly readable. I went back to page break and still 1 page.

Is it therefore not possible for a chart image to involve more than 1 page wide? That just doesn't seem right. There's surely tons of instances where folks have huge data sets that require multiple pages of chart representation?


Mark