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
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