------ Register to get rid of these "In Post" ads! ------


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 here:
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
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-miscellaneous/112014-pivot-table-hide-blank.html#post401565
> 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