Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide or replace (blank) in a Pivot Table Column | Excel Worksheet Functions | |||
how can i hide zero results row in a pivot table? | Excel Discussion (Misc queries) | |||
hide (blank) in pivot table | Excel Discussion (Misc queries) | |||
how to hide 0 values in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - hide blank cells | Excel Discussion (Misc queries) |