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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,118,788
Messages
5,574,294
Members
412,585
Latest member
devtr
Top