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...
9 views
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.
- many thanks exactly what I needed!
