Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Removing Pivit Table Items
I'm way over my head here, so bear with me -
I have a pivot table for prescription drug charges. The ROW column has the 12 months. When I first set this up, there were several other subheadings (drug store/size/etc.) which appeared, correctly, after the 'months' listing. I have now revised the chart so that all I want are the 12 months. However, try as I might, the old subheadings persist in appearing in the row list. In addition, a couple of new items have appeared, as far as I know out of thin air - 'formula1" and 'blank' How can I delete these extraneous items. They don't appear anywhere in my base data. Thx Dave |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Removing Pivit Table Items
Hi,
What version of Excel are you using? In 2003 and earlier, you can remove a new field by dragging it off the pivot table. (drag the field button at the top of the column off the pivot table) If it is not a field but an item, then open the filter for the field and uncheck the items you don't want to see. By default if an item ever existed in a field it is retained on the filter list. If you want to clear the list, not just hide the item, drag the field button off the pivot table, click the Refresh button, and drag the field button back on to the pivot table. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Dave" wrote: I'm way over my head here, so bear with me - I have a pivot table for prescription drug charges. The ROW column has the 12 months. When I first set this up, there were several other subheadings (drug store/size/etc.) which appeared, correctly, after the 'months' listing. I have now revised the chart so that all I want are the 12 months. However, try as I might, the old subheadings persist in appearing in the row list. In addition, a couple of new items have appeared, as far as I know out of thin air - 'formula1" and 'blank' How can I delete these extraneous items. They don't appear anywhere in my base data. Thx Dave |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Removing Pivit Table Items
Thank you Shane -
Office (Exell) 2003 I would like to remove the extraneous items from the field list, but when I drag the field button off/refresh/replace they are still there. What to do? Dave "Shane Devenshire" wrote in message ... Hi, What version of Excel are you using? In 2003 and earlier, you can remove a new field by dragging it off the pivot table. (drag the field button at the top of the column off the pivot table) If it is not a field but an item, then open the filter for the field and uncheck the items you don't want to see. By default if an item ever existed in a field it is retained on the filter list. If you want to clear the list, not just hide the item, drag the field button off the pivot table, click the Refresh button, and drag the field button back on to the pivot table. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Dave" wrote: I'm way over my head here, so bear with me - I have a pivot table for prescription drug charges. The ROW column has the 12 months. When I first set this up, there were several other subheadings (drug store/size/etc.) which appeared, correctly, after the 'months' listing. I have now revised the chart so that all I want are the 12 months. However, try as I might, the old subheadings persist in appearing in the row list. In addition, a couple of new items have appeared, as far as I know out of thin air - 'formula1" and 'blank' How can I delete these extraneous items. They don't appear anywhere in my base data. Thx Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing single items from list | Excel Worksheet Functions | |||
Pivit table | Excel Discussion (Misc queries) | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
Pivit table not displaying data | Excel Discussion (Misc queries) | |||
pivit table will not caculate | Excel Discussion (Misc queries) |