select chart data from multiple worksheets


  • I have just put up an EXCEL 2007 Workbook for you at:-

     - item 164.

    1. If you open the Workbook you should get taken through to the Worksheet called:-


    This is the end result where you compare the years in question (2010 / 2011 / 2012).

    2. See the Worksheet called:-


     - for an explanation of how I have got your data into this Worksheet.

    It's pretty straightforward. 

    Monday, November 05, 2012 3:51 PM

All replies