tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,926
- Office Version
- 365
- 2019
- Platform
- Windows
I recorded some code to change the source data for a chart:
but when I changed the chart from a column chart to a map, I get the folowing error message:
What is wrong?
Thanks
Code:
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SetSourceData Source:=Range("Sheet1!$A$1:$B$3")
but when I changed the chart from a column chart to a map, I get the folowing error message:
Code:
run-time error 445
Object doesn't support this action
What is wrong?
Thanks