Forum Discussion
Create new worksheet with one graph using single cell input from multiple worksheets
GIVEN: - I have an Excel 2003 (don't yell at me!) spreadsheet with multiple worksheets. - Each worksheet has two columns (text label, numeric value) and a graph showing all the columns' values. - ...
That could be done with Excel for web if
- you have texts "Total" or any other one, but the same for all sheets, in Column A against total value in column B
- you add manually sheet names into the master sheet
That could be like