Showing alias for PivotFields
 

Hello,

I've got a problem and I'm not sure if it can be handled at all.
I receive data from a database and load them into an Excel-file. There macro
actualizes all PivotTables and PivotCharts in the file.
My problem is that one chart presents data from different locations and
these locations are shown on the X-Axis as 'City, Country' (an example would
be Paris, France). I just need the City of the location ('Paris, France' -
'Paris'). Is there a way to display alias-names in the PivotTable? The
original format cannot be changed because I can not change the external
database.

Thanks