G Guest Apr 14, 2005 #1 how can i chart data from the same cell on multiple sheets? when i enter sheet1:sheet5!a5 i get a invalid reference error.
how can i chart data from the same cell on multiple sheets? when i enter sheet1:sheet5!a5 i get a invalid reference error.
J Jon Peltier Apr 15, 2005 #2 The values for a chartseries must all come from a single chart. You need to create a summary range on a worksheet to hold the values. This page has a few hints: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
The values for a chartseries must all come from a single chart. You need to create a summary range on a worksheet to hold the values. This page has a few hints: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______
