i have amulti worksheet and i need to make a chart for all
S Shane Devenshire Jan 25, 2009 #2 Hi, If I understand, you want to create a chart which uses data from multiple sheets? If so the easiest way is to build a summary area which pulls the data in from the different sheets and then chart that.
Hi, If I understand, you want to create a chart which uses data from multiple sheets? If so the easiest way is to build a summary area which pulls the data in from the different sheets and then chart that.
J Jon Peltier Jan 25, 2009 #3 This page adds a little information to Shane's post: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html - Jon
This page adds a little information to Shane's post: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html - Jon
