Forum Discussion
Deleted
Jan 09, 2018Adding 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...
Deleted
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.
SergeiBaklan
Jan 10, 2018MVP
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.
- DeletedJan 11, 2018
Thank you. It worked
- jessbwellOct 19, 2023Copper Contributor
Thank you so much ! This helped me. SergeiBaklan
- SergeiBaklanOct 19, 2023MVP
jessbwell , you are welcome, glad to help.