Displaying multiple currencies in a pivot chart

Putch66

New Member
Joined
Sep 25, 2019
Messages
1
Afternoon All
Have a multi-currency pivot table (european).
Unfortunately, when creating the associated pivot chart (is a pie chart in this instance but would be the same for any chart) I don't get the option to format to source with the obvious outcome being non-currency values which my colleagues would find slightly annoying.
Is there any way I can link the chart data to the relevant currency?
Thanks in advance, you lovely people.
KR
Mike
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,118,073
Messages
5,570,036
Members
412,307
Latest member
Sindhu2302
Top