Charting information from a number of worksheets
Dear All
I have a spreadsheet set up with one worksheet for each week of the year. The spreadsheets all have exactly the same template. I would like to plot a graph of the data held in cell B4 in all of the worksheets. I want to end up with a graph with the weeks across the bottom and the value of B4 for each week on the y axis. Is this possible? Thanks Ian |
While searching for the answer to my own question - I found this - which may
be helpful for your issue. http://www.peltiertech.com/Excel/Cha...iffSheets.html |
All times are GMT +1. The time now is 06:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com