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 » Charts
Charts
Resolved · Medium Priority · Version 2007
Tue 20 Sep 2011, 16:45Delegate Fareen said...
Fareen has attended:
Excel VBA Intro Intermediate course
Charts
How do you create your chart as a new sheet (not just within a new sheet)?
Tue 27 Sep 2011, 00:33Trainer Mark said...
RE: Charts
Hello Fareen,
The code for the chart is the same, but you need to include before that code the following one line to create a new chart sheet.
Charts.Add (this is what you need to type)
ActiveChart.ChartType = xl3DColumn
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Mon 3 Oct 2011: 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:Customize the toolbar in Excel 2010You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please. |
