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

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