Need a little assistance. Creating a pie chart and I have the following code
ActiveChart.ChartType = xlPie
ActiveChart.SetSourceData Source:=Sheets("RCSupport").Range("F1:H28"), PlotBy:= _
ActiveChart.Location Where:=xlLocationAsObject, Name:="Scorecard (2)"
ActiveChart.ChartTitle.Text = "Schedule Delay Averages # of Days/Store"
ActiveChart.ShowAllFieldButtons = False
ActiveChart.ApplyDataLabels xlDataLabelsShowValue, xlDataLabelsPercent
ActiveChart.SeriesCollection(1).HasLeaderLines = False
I can't figure out how to get the category name, value, and percent to all show on the pie chart and how to place the chart in a specific location would like it to be from a13:l42