I have a Excel spreadsheet that is edited primarily from my desktop computer at work (which has two large screens) but is also sometimes edited on my personal laptop computer from home (which has one relatively small screen). The spreadsheet has a chart in it that looks fine on one of my large screens at work, but when I open the file at home, it runs off the edge of the page (as can be observed in the screenshot here).
I thought Excel took care of fitting the chart to the available space on its own, but evidently not (at least not in this case). I have tried zooming in and out and resizing the chart to try to trigger Excel's auto-resize, but nothing seems to work.
Does anyone know how to get the chart to fit the page it has been inserted into?
I am using Office 2010. Additionally, there are VBA macros the pull the data for the chart and make slight changes to it (i.e. plot order, line color, setting the horizontal axis to fit the data).