Results 1 to 2 of 2
Thread: Chart Sizing (Excel 97)
2003-06-03, 10:06 #1
- Join Date
- Feb 2002
- Sussex, England
- Thanked 0 Times in 0 Posts
Chart Sizing (Excel 97)
I am creating a spreadsheet that has automated charts in it. The chart data is entered into a dialog box on start up. The charts are already in the spreadsheet, the depending on the option chosen they can be different types of chart e.g. Pie, Column or Line. When the data is entered into them, they need to be different sizes depending on the chart type.
I specify the size and location using the following code:
Selection.Left = 30
Selection.Top = 30
Selection.Width = 400
Selection.Height = 350
With different numbers for a Pie chart. The charts also don't always have a Side title so that can make a difference.
The problem is that the chart comes out too wide with the Side title over the numbers if there is one. The Charts are interactive and when you click them it launches another dialog box to change properties/data of the chart if you want to. The code behind these tells the chart to be the same size and position.
If you launch this UserForm and keep all the data the same then press OK, the chart changes slightly, then if you repeat launching and keeping the data the same it gets to how I want it to look.
I thought maybe the code was moving but if you repeat it any more times it stays the same size and position.
I have tried just adding the code in again to repeat it but it still comes out wrong as before.
Has anyone ever come across this before? Is it a bug?
Any suggestions would be very welcome.
2003-06-03, 10:50 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Chart Sizing (Excel 97)
This question has also been asked in the Excel board. I am locking this thread to avoid confusion and duplication. Anyone who wants to help Chesney can do so in the thread starting at <post#=260623>post 260623</post#>.