Excel Project Timeline Template Chart View

[Darrel Eady]

I am using the Excel Project Timeline Template and would like to extend the chart view to show more than 30 days at a time when I print it in landscape. When I resize or stretch the chart area limits, it scales the contents of the view, not allowing me to show more than 30 days. Hopefully that makes sense! How do I resize the chart view to show 60 days at a time without having to scroll?

[#2]

If you unhide the 'calcs' worksheet, you will see the data behind the chart.

The X values of many of the series in the chart are calcs!$E$31:$AH$31, which you can see are the dates in the labels near the bottom of the chart. This is a range 1 row high and 30 columns wide, so the 'calcs' worksheet only has data for 30 days. (All of the Y values use similar ranges for Y values, for example calcs!$E$32:$AH$32).

You would need to expand the data ranges on 'calcs' out to column BL (filling all the formulas etc.) and then adjust the series formulas of all series in the chart to use the new wider ranges.