As we all know,
Dim wkSheet as Worksheet
Set wkSheet = ActiveSheet
will make it so the active sheet is defined by wkSheet and you can do what you want with it using wkSheet
My question is, how do you do this with a chart?
You can use ActiveChart. to do almost anything you want with the chart.
However I seem unable to set the chart as a varible/object/shape (or what ever it needs to be)
Public Sub cht()
Dim v As Chart
Set v = ActiveChart
End Sub
This worked for me. Is there an active chart?
Series etc belong to Chart, which may be contained in a Chartobject, unless it's a separate sheet.
If you needed to use the chartObject variable type you can do it this way
Dim wb As Workbook
Dim ws As Worksheet
Dim chrt As ChartObject
Set wb = ActiveWorkbook
Set ws = ActiveSheet
Set chrt = ws.ChartObjects(wb.ActiveChart.Parent.Name)
Dim strTemp As String
ActiveSheet.Shapes.AddChart2(317, xlRadar).Select
strTemp = ActiveChart.Name
Debug.Print strTemp
End Sub
