| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Source in Pivot Tables
I am working in Excel 2003. I have a bumch of expense catergories that I
would like to put into a pivot table. I also have a month and year column. So I put my year in the column part of the Pivot Table Chart Wizard and my month is the row part, and then all my expenses in the data portion. This works to a point. As soon as I go to my Pivot Table and change my dad to only view 1 or 2 expenses I lose the rest of the data. I have to go back in and add the rest again. Why is it doing this?? Is there a better way?? What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Pivot tables using the same source data | Excel Discussion (Misc queries) | |||
| Identifying Source Data for Pivot Tables | Excel Discussion (Misc queries) | |||
| Source Data in Pivot Tables | Excel Worksheet Functions | |||
| Force pivot tables to use same source data | Excel Discussion (Misc queries) | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Threaded Mode
