Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 2nd 09, 10:45 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 53
Default Pivot Table - Hide (blank)

Hi,
I have a spreadsheet that has about 500 rows and grows by about 10 each day,
I have a pivot chart that looks at this SS, and retruns a chart based on a
value within a field - it's a simple "count" of how many "x" values occur in
the 500+

As my data set graws each day, rather than change the source data settings,
I've left it at row 600 which is ok, but when the PT & chart are created they
have field for (blank) - it doesn't have a value in it, but it doesn't look
good when I use my PT into power point - is there anyway I can tell the PT to
ignore the blanks?

Thanks

  #2   Report Post  
Old July 2nd 09, 12:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Pivot Table - Hide (blank)

Instead of defining a set range, you may find it much easier to use a defined
range that expands and contracts with your data.

Debra Dalgleish explains dynamic range names he
http://contextures.com/xlNames01.html#Dynamic

Dave Eade wrote:

Hi,
I have a spreadsheet that has about 500 rows and grows by about 10 each day,
I have a pivot chart that looks at this SS, and retruns a chart based on a
value within a field - it's a simple "count" of how many "x" values occur in
the 500+

As my data set graws each day, rather than change the source data settings,
I've left it at row 600 which is ok, but when the PT & chart are created they
have field for (blank) - it doesn't have a value in it, but it doesn't look
good when I use my PT into power point - is there anyway I can tell the PT to
ignore the blanks?

Thanks


--

Dave Peterson


Reply
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
How to hide or replace (blank) in a Pivot Table Column enna49 Excel Worksheet Functions 3 April 17th 07 02:54 AM
how can i hide zero results row in a pivot table? Deb Excel Discussion (Misc queries) 0 September 21st 06 07:30 PM
hide (blank) in pivot table Nynke Excel Discussion (Misc queries) 1 June 12th 06 06:09 PM
how to hide 0 values in pivot table maryj Excel Discussion (Misc queries) 3 April 1st 06 09:49 AM
Pivot Table - hide blank cells Kirk P. Excel Discussion (Misc queries) 1 August 18th 05 02:42 AM


All times are GMT +1. The time now is 01:40 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017