Dynamic Pie Charts

[silecdon@yahoo.com]

I am trying to have a pie chart automatically update based on values that either exist or don't exist in my source table - what? Let me show you.


My source table looks up values and based on customer criteria it returns this data

I only want to chart those locations with values and exclude the blanks. I know I can sort the data column and re-specify the range, but I want it automatic.


Any help would be appreciated.


Location Data

A 3,181

B 305,823

C 1,720,148

D -

E -

F 1,213


When I change the customer, I get different results.

 

[Montrey]

Make a formula that displays #N/A if the cell isblank. #N/A indicates to the graph to not display.


Can't really do much more without a sample file.