is there a way to setup a pie chart that auto updates as the data on another sheet is modified?
J jake Mar 9, 2009 #1 is there a way to setup a pie chart that auto updates as the data on another sheet is modified?
D dlw Mar 9, 2009 #2 Yes, all the ranges in the pie chart can be external references: [filename.xls]sheetname!a1.a10 like that
Yes, all the ranges in the pie chart can be external references: [filename.xls]sheetname!a1.a10 like that
