andynetter
New Member
- Joined
- Jun 9, 2008
- Messages
- 1
Hi all,
New to this board and hoping someone can help.
I have a PivotChart, which is currently displaying sales to a range of customers. The customer names are on the Category axis. What I need to do is change the Category names to something like "Customer A" to hide the true Customer names.
So for example, instead of showing it as HP / Acer / Dell, I need it to show Customer A / Customer B / Customer C.
I realise I can do this by changing the names in the source pivot, but I need to find a way of changing them on the PivotChart only, using some VBA code. I'm open to any creative suggestions....!
Many thanks in advance,
Andy
New to this board and hoping someone can help.
I have a PivotChart, which is currently displaying sales to a range of customers. The customer names are on the Category axis. What I need to do is change the Category names to something like "Customer A" to hide the true Customer names.
So for example, instead of showing it as HP / Acer / Dell, I need it to show Customer A / Customer B / Customer C.
I realise I can do this by changing the names in the source pivot, but I need to find a way of changing them on the PivotChart only, using some VBA code. I'm open to any creative suggestions....!
Many thanks in advance,
Andy