Chart Display -- fit window or zoomable?
I have two spreadsheet workbooks, both created from the same version
of excel, both created by yours truly. There is a difference between them that I cannot explain and I cannot migrate from one to the other. In one workbook, (call it "A") I have a chart which is "on a tab" (rather than embedded in a sheet). This chart can be zoomed to whatever scale I like, 200%, 100%, 75%, 50%, 25% or Selection. This feature is easy enough to understand. As I resize the Excel application, the zoom stays fixed, and I have to "re-zoom" (usually to "Selection") to see the whole chart. That's fine. Except... In another workbook (call it "B"), I have another chart that is "on a tab", but this chart cannot be zoomed. The zoom control on the toolbar is grayed out and disabled. The chart simply fits itself to the constraints of the application. I never have "re-zoom" it when I resize Excel. What setting controls this? The A chart looks like a piece of paper set on a gray background. If I zoom to 25% it's a very small white piece of paper on a largely gray application background. The B chart has no gray behind it. It doesn't look like a piece of paper set down. It always reaches perfectly to the extent of the Excel window. Any insight out there? I'd like both of these workbooks to work like my workbook B. I don't wanna have to tinker with the zoom levels. I just don't know how to enable that behavior. ---- This is probably relevant, so I'll add it. In the A workbook, EVERY chart is like a zoomable piece of paper. In the B workbook, EVERY chart is unzoomable and simply fits whatever size Excel takes. I have yet to see a workbook which exhibits both behaviors. Brian Herbert Withun |
Chart Display -- fit window or zoomable?
The following setting is different on the two charts:
Tools menu Options Chart Tab [ ] Chart Sizes with Window Frame - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "SpreadsheetBrian" wrote in message ups.com... I have two spreadsheet workbooks, both created from the same version of excel, both created by yours truly. There is a difference between them that I cannot explain and I cannot migrate from one to the other. In one workbook, (call it "A") I have a chart which is "on a tab" (rather than embedded in a sheet). This chart can be zoomed to whatever scale I like, 200%, 100%, 75%, 50%, 25% or Selection. This feature is easy enough to understand. As I resize the Excel application, the zoom stays fixed, and I have to "re-zoom" (usually to "Selection") to see the whole chart. That's fine. Except... In another workbook (call it "B"), I have another chart that is "on a tab", but this chart cannot be zoomed. The zoom control on the toolbar is grayed out and disabled. The chart simply fits itself to the constraints of the application. I never have "re-zoom" it when I resize Excel. What setting controls this? The A chart looks like a piece of paper set on a gray background. If I zoom to 25% it's a very small white piece of paper on a largely gray application background. The B chart has no gray behind it. It doesn't look like a piece of paper set down. It always reaches perfectly to the extent of the Excel window. Any insight out there? I'd like both of these workbooks to work like my workbook B. I don't wanna have to tinker with the zoom levels. I just don't know how to enable that behavior. ---- This is probably relevant, so I'll add it. In the A workbook, EVERY chart is like a zoomable piece of paper. In the B workbook, EVERY chart is unzoomable and simply fits whatever size Excel takes. I have yet to see a workbook which exhibits both behaviors. Brian Herbert Withun |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com