P Paul Dec 23, 2003 #1 Does anyone know how I can select cells from multiple worksheets in the same spreadsheet and show the data in a chart?
Does anyone know how I can select cells from multiple worksheets in the same spreadsheet and show the data in a chart?
J Jon Peltier Dec 23, 2003 #2 Paul - You have to generate a summary sheet, which is linked to the values on the other sheets. This summary range is used to create the chart. http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html - Jon
Paul - You have to generate a summary sheet, which is linked to the values on the other sheets. This summary range is used to create the chart. http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html - Jon
