Menu
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.
874
Step 1: Start Sub Procedure. Step 2: Define the variable as Chart. Step 3: Since the chart is an object variable, we need to Set it. The above code will add a new sheet as a chart sheet, not a worksheet.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
