pivot table drop list

I have created a pivot table from a data sheet which is the different real estates of a client. I created to data by having 4 options for residence (if more than one home). For example the set up is two column:
Residence 1 $150,000
Residence 2 $200,000
Residence 3 $0
Residence 4 $0

Currently, I have a client that has a home in Ohio and Florida, and I replace Residence 1 and 2 with the location of the residence on the data worksheet. Is there a way where the drop list for the pivot chart will replace Residence 1 and 2 instead of just adding Ohio and Florida to the the bottom of the drop list?

Since I have replaced them on the data worksheet, I would like the drop list to show: Ohio, Flordia, Residence 3, Residence 4. Is there a way this can be done?

MT

Hi
see:
http://www.contextures.com/xlPivot04.html

--
Regards
Frank Kabel
Frankfurt, Germany


MT wrote:
I have created a pivot table from a data sheet which is the different
real estates of a client. I created to data by having 4 options for
residence (if more than one home). For example the set up is two
column:
Residence 1 $150,000
Residence 2 $200,000
Residence 3 $0
Residence 4 $0

Currently, I have a client that has a home in Ohio and Florida, and I
replace Residence 1 and 2 with the location of the residence on the
data worksheet. Is there a way where the drop list for the pivot
chart will replace Residence 1 and 2 instead of just adding Ohio and
Florida to the the bottom of the drop list?

Since I have replaced them on the data worksheet, I would like the
drop list to show: Ohio, Flordia, Residence 3, Residence 4. Is there
a way this can be done?

MT