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...
I was hoping that would work but it didn't. All the numbers in the pivot data have been converted to currency but the data table in the pivot chart still reads as general, even after I refresh.
Brittany,
How do you generate your Power Chart? If like
Insert->Power Chart-> Use this workbook data model
and from table from data model when changing format of PivotTable colums won't affect formats for chart data table.
Thank you. It worked
Thank you so much ! This helped me. SergeiBaklan
jessbwell , you are welcome, glad to help.
