Excel Charts using VBA

The UK's most regular instructor-led training courses.
Training information: excel 2003 training · Excel course · VBA courses London

Resolved · Low Priority · Version 2003

Excel Charts using VBA

Monique has attended:
Excel VBA course

by - delegate Monique [1 post] (2008 Aug 26 Tue, 16:26) Reply

Is it possible to create charts in Excel using VBA. For example, having created a PivotTable in VBA with yearly totals, can you plot a chart of these values?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel Charts using VBA

by - trainer Laura silver contributer [86 posts] (2008 Sep 17 Wed, 10:40) Reply

You can do almost anything in VBA that you can do as an Excel user. The easiest way to find out how the code will look is to record the code of producing the chart and then take a look at the code and work from there.

I recorded creating a chart from a pivot table and got the following code. My pivot table was on Sheet4 and A6 was inside it.

Sub Macro2()
Charts.Add
ActiveChart.SetSourceData Source:=Sheets("Sheet4").Range("A6")
ActiveChart.Location Where:=xlLocationAsNewSheet
End Sub

Formatting the chart to appear as you need is another record a macro and see what it does and tweak it to suit your needs.

Laura GB

· Creating Charts with Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training Course
· Fun Things I've Done With Excel
· Why Should I Learn Visual Basic in Excel?

Please browse our web site to find out more about
excel 2003 training and other Microsoft training courses.

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips