Forum Discussion
Adding currency symbol to a pivot chart data table
Hello,
right-click any number in the pivot table series, click Value Field Settings and in the dialog click the Number format button. Select the desired format. It will be applied to the pivot table and also to the data table of the pivot chart.
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.
