Forum Discussion
Adding currency symbol to a pivot chart data table
Hello, does anyone know how to add currency symbols to a pivot chart data table? I have done everything, I right clicked on the chart and went to values --> value field settings --> show value as cur...
Hi Brittany
Just to check my understanding, did you right click onto the desired cell (that contains the number) in the PivotTable, go to Value Field Settings > Number Format, and change it to Currency?
That's the way I know to add it in, but others in the forum might know a better way?
Good luck!
Damien
Yes, I did that and no change.
- Mmm the only other thing I can think of is if you can upload a sample of the file, we can have a play and see if we can set it for you!
Cheers
Damien
