none
select chart data from multiple worksheets

Answers

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

    http://www.pierrefondes.com/

     - item 164.

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

    Sheet5

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

    2. See the Worksheet called:-

    year_totals

     - 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