Create a graphic with information from many sheets
I have 31 sheets in a single excel file, each one has these follow information i want: date and value, those information are located in the same place in each sheet, for example, sheet_1 A1 has a date value and sheet_2 A1 too.I want to create a graphic with these information, date on the horizontal axis and values from each date on the vertical axis. Can you help me?
Use 3-D formula to summarize data on a single sheet and pivot it
Use 3-D formula to summarize data on a single sheet and pivot it
Use the Wizard for Pivots
When you want to create a graphic with information from many sheets you must activate the wizard for pivots: see for instructions: http://www.youtube.com/watch
Microsoft Excel 2007 and 2010 hide the PivotChart Wizard, which is not shown in the Ribbon. Without Classic Menu for Excel 2007 or 2010 installed, it is not so intuitive to get this function. If you do need to use PivotChart Wizard, there still are several ways to configure it.
Read more: How to Use the Pivot Table Wizard in Excel | eHow.com http://www.ehow.com/how_13020_pivot-table-wizard.html#ixzz2Q3lEFVKe