Centering Charts in Macro

  • Thread starter Thread starter Ian B.
  • Start date Start date
I

Ian B.

I've got most of my macro sorted now that I mentioned in a previous post,
however I have one problem, charts seem to position themselves on the screen
inconsistently. Is there some way I can centre the view of the chart?

TIA,
Ian
 
I've got most of my macro sorted now that I mentioned in a previous
post, however I have one problem, charts seem to position themselves
on the screen inconsistently. Is there some way I can centre the view
of the chart?
Click to expand...

Yes. The macro can modify the chart's position.
 
Jonathan Rynd said:
Yes. The macro can modify the chart's position.
Click to expand...

How so? Please inform me, I searched the help but couldn't find out how.

In the end (it's too late now, I've done the presentation) I found not
hiding the scroll bars did the job, bizarrely.

Ian
 
How so? Please inform me, I searched the help but couldn't find out how.
Click to expand...

Output the chart to a worksheet instead of to a new chart sheet.

Then position the chart on the sheet by setting

ActiveWorksheet.ChartObjects(0).Left
ActiveWorksheet.ChartObjects(0).Top
ActiveWorksheet.CHartObjects(0).Height
ActiveWorksheet.CHartObjects(0).Width
 
Back
Top