Creating a pie-chart in excel using VBA

Question

I am new to VBA and am trying to learn how to create a pie-chart out of certain values on the Excel spreadsheet. I know how to do the bar charts, but I was wondering whether you guys are aware of online resources or tutorials for this.

mechanical_meat · Accepted Answer · 2010-11-02 23:34:18Z

10

Tools -> Macro -> Record New Macro produces this code which you can then tweak to your specific needs:

Charts.Add
ActiveChart.ChartType = xlPie
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:A4"), PlotBy:= _
    xlColumns
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
ActiveChart.HasTitle = False

answered Nov 2, 2010 at 23:34

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Apollon1954 Over a year ago

Hey mate.. Can i ask if you know how to put position in my chart?

Apollon1954 Over a year ago

What i found is to put .left ="something" and .top = "something" but i didn't manage to do it..

mathiasfk Over a year ago

ActiveSheet.Shapes(1).Left = 100 ActiveSheet.Shapes(1).Top = 100

Collectives™ on Stack Overflow

Creating a pie-chart in excel using VBA

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related