So now I am trying to apply this to my chart at work and I am having trouble with the
Set tbl = Sheets("Pivot Table").PivotTables(1)
part of the formula. When setting it on another chart what property should I change and how would I find it?