Help with a table?? Or chart??

[Mcnitchell]

Hello, I have spreadsheet with several work sheets. Each work sheet represents a month. So, with each new month I create a new work sheet and rename it "February 2012" or whatever that particular month is. I track my expenses each month. So, for example, I track my electric bill, gas bill, trash, general utilities, etc., each month. What I would like, and need help with, is creating a "floating" table or graph showing an on-going automatically accumulating sum of all the work sheets for my electric bill, or gas bill, or etc... Is this possible? Or, does this not make any sense?

Thanks for any help you can offer!

Nick

[lmp]

Hello,

why do you start a new sheet every month? This complicates things. Keep all data in one sheet in one table without any blank rows or columns. Then you can build a pivot table and/or pivot chart with just a few clicks. Pivot tables have filters that can then be used to look at subsets of the data, e.g. a single month or a single category.

Get started with pivot tables here: http://peltiertech.com/Excel/Pivots/pivotstart.htm