Shrinking Graphs in Excel 2007
in [Charts]
|
Prev: how to make grand total to show up on pivotchart?
Next: How can I customise colours used in charts and keep those colours.
From: trip_to_tokyo on 6 May 2010 07:15 Sean, this is from Ed Ferrero MVP:- A couple of things to try; Check your printer driver. It may seem strange, but the printer you use can have an effect on how charts are rendered. See this article http://support.microsoft.com/kb/111249 Remove graphic elements embedded in the chart object. There are things like textboxes, activeX controls and the like. I remember seeing a suggestion to place the chart on its own sheet (change Location). Don't know if this would work for you. Use a macro to resize the charts every time you open the worksheet. This is just a workaround if other things do not work. Sample code would go something like this; Private Sub Workbook_Open() Dim oCht As ChartObjectFor Each oCht In ActiveSheet.ChartObjects oCht.Width = 400 oCht.Height = 300 Next End Sub Since most of us cannot reproduce the problem, it would be good if you could post back here any solution you find. "seanpottinger" wrote: > Apologies, but I've been searching for shrinking charts and graphs and can't > find anything? Can someone please post me a link? > > many thanks > > "trip_to_tokyo" wrote: > > > Sean, there have been other postings on shrinking graphs (you can see for > > yourself in the Search facility). > > > > I wouldn't hold your breath for a hotfix. > > > > > > "seanpottinger" wrote: > > > > > We have a particular issue with some spreadsheets and shrinking graphs on > > > each 'save as'. As they have older VB code, we can't save it under excel 2007 > > > format and need to always save under 97-2003 format. This issue only started > > > occuring in the last month or so. It occurs on all PC's and for all sheets. > > > Is anybody aware of this issue or know if a hotfix is coming out? > > > > > > Many thanks |