98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Creating a Graph in VBA for Excel
Creating a Graph in VBA for Excel
Resolved · Medium Priority · Version 2003
Tue 29 Sep 2009, 15:19Delegate Chris said...
Chris has attended:
Excel VBA Advanced course
Creating a Graph in VBA for Excel
As asked on the course, when you are creating a graph in VBA for display on an Excel worksheet, is there a way to determine the graph's size on its creation rather than having to resize (and consequently estimate the growth/reduction percentage)?
Thu 1 Oct 2009, 10:27Trainer Stephen said...
RE: Creating a Graph in VBA for Excel
Hi Chris
Thanks for the question
I have discovered that setting the width and height properties can be accessed by identifying the chart through the chart objects collection.
e.g
ActiveSheet.ChartObjects(1).Width = 600works fine
I am still understanding how this relates to the width / height properties of the chart area etc. I will follow up when I know more
Regards
Stephen
Wed 7 Oct 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display developer tab - Excel 2010a. In Excel, click on the File tab |
