I want to create a pie chart and set the source data. I've spent a long time searching, with this being the most helpful. I keep getting this error, "run time error 2147221080 (800401a8): automation error" for the following code.
Sub createchart()
Charts.Add
With ActiveChart...