Positioning the Chart Title by VBA code in Excel 2010.
There are two options:
xlChartElementPositionCustom
xlChartElementPositionAutomatic
So using code:
oChart.ChartTitle.Position = xlChartElementPositionAutomatic will make it centre at the top
One interesting chart add-in we did forced the user to enter the "Source" of the data which was placed in the chart title in small font. Just one of the things we have been asked to do for consistency in formatting Excel across an organization.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment