ExcelBanter - 3-D references in charts

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - 3-D references in charts (https://www.excelbanter.com/excel-worksheet-functions/7461-3-d-references-charts.html)

Chez

3-D references in charts

Can I get sourse data for a line graph from multiple worksheets in a workbook?

PeterAtherton

You can't do it this way. But if the layout is the same on each sheet you can
sum the data e.g. =SUM(Sheet2:Sheet3!C2) and graph that

Regards
Peter

"Chez" wrote:

Can I get sourse data for a line graph from multiple worksheets in a workbook?

All times are GMT +1. The time now is 01:52 AM.