View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Markus Scheible[_2_] Markus Scheible[_2_] is offline
external usenet poster
 
Posts: 95
Default Changing chart title changes position of chart

Good Morning Bing,

Problem is that each time the title undergoes a smaller

font size change,
the chart actually changes position within the chart area

by moving up.

Also any labels i've placed in the chart area also

changes position and move
up as well.

Anyone have any ideas why and how to stop this?


well, afaik this is because Excel automatically arranges
all elements within a chart so that every element has the
max size. So if e.g. the chart title becomes smaller,
excel makes the chartarea larger...

I think you could stop this by using the

AutoScaleFont Property

for each element within the chart... e.g.

Selection.AutoScaleFont = False

Best

Markus