Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Charts
|
|
|
The UK's most regular 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. |
Charts
Resolved · Medium Priority · Version 2007
Reply 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)?
For upcoming training course dates see: Pricing & availability
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.
|