I am hoping to create a pie chart that will select data points dynamically. I
have a static range (51 rows in column a & b) but I only want to select the
rows that have non-zero values in column b to be inputs for the pie chart.
(becuase the rows with non-zero values will be subject to change).

I have tried naming the two columns as ranges using a counta function which
selects the right number of cells (based on the ones that have non-zero
values) but selects the first 9 cells lets say instead of skipping the empty
ones and selecting the 9 cells with non-zero values

I also tried a macro that would assign a name to the range selecting the
first sell and then xldown after running a macro that hides the rows with
zero values... that ends up selecting the whole range and not skipping the
hidden cells


any help would be greatly appreciated!!
--
Thanks,

Galen

Just a thought, but why not use a macro to create a range that only contains
the non-zero values, that use that as the basis for your pie chart.

Paul W Smith


"Galen" wrote in message
...
I am hoping to create a pie chart that will select data points dynamically.
I
have a static range (51 rows in column a & b) but I only want to select
the
rows that have non-zero values in column b to be inputs for the pie chart.
(becuase the rows with non-zero values will be subject to change).

I have tried naming the two columns as ranges using a counta function
which
selects the right number of cells (based on the ones that have non-zero
values) but selects the first 9 cells lets say instead of skipping the
empty
ones and selecting the 9 cells with non-zero values

I also tried a macro that would assign a name to the range selecting the
first sell and then xldown after running a macro that hides the rows with
zero values... that ends up selecting the whole range and not skipping the
hidden cells


any help would be greatly appreciated!!
--
Thanks,

Galen

thanks!
--
Thanks,

Galen


"Paul W Smith" wrote:

Just a thought, but why not use a macro to create a range that only contains
the non-zero values, that use that as the basis for your pie chart.

Paul W Smith


"Galen" wrote in message
...
I am hoping to create a pie chart that will select data points dynamically.
I
have a static range (51 rows in column a & b) but I only want to select
the
rows that have non-zero values in column b to be inputs for the pie chart.
(becuase the rows with non-zero values will be subject to change).

I have tried naming the two columns as ranges using a counta function
which
selects the right number of cells (based on the ones that have non-zero
values) but selects the first 9 cells lets say instead of skipping the
empty
ones and selecting the 9 cells with non-zero values

I also tried a macro that would assign a name to the range selecting the
first sell and then xldown after running a macro that hides the rows with
zero values... that ends up selecting the whole range and not skipping the
hidden cells


any help would be greatly appreciated!!
--
Thanks,

Galen