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?

Almir's picture

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.

  • Click File Tab, and click “Options” item.
  • Click the Customize Ribbon in the Excel Options window, and then, you will see Customize the Ribbon in the right pane. Choose Commands Not in the Ribbon by clicking the arrow, and then use the scroll bar to search for the PivotTable and PivotChart Wizard.
  • When finally find out the Wizard, click Add to add it into the Ribbon, and then click OK to finish the step.

Read more: How to Use the Pivot Table Wizard in Excel | eHow.com http://www.ehow.com/how_13020_pivot-table-wizard.html#ixzz2Q3lEFVKe