LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 55
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
removing single items from list jenn Excel Worksheet Functions 6 November 8th 08 02:28 PM
Pivit table jamessinc Excel Discussion (Misc queries) 1 December 28th 07 06:13 PM
Pivit table- cell on spread sheet referencing pivot table field David M Charts and Charting in Excel 2 August 18th 07 07:46 PM
Pivit table not displaying data Gimp Excel Discussion (Misc queries) 3 February 6th 07 10:33 PM
pivit table will not caculate Mike Excel Discussion (Misc queries) 1 March 28th 05 10:57 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"