Jan 09 2018 01:31 PM
Jan 09 2018 01:31 PM
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 currency. The Y axis is showing the currency but the table under the chart will not change. Again this is is a pivot chart and the pivot table is formatted to show currency as well. I have attached a picture with an example of what the chart currently looks like. Thank you.
Jan 09 2018 07:29 PM - edited Jan 09 2018 09:04 PM
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
Jan 09 2018 07:29 PM
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.
Jan 10 2018 06:33 AM
Yes, I did that and no change.
Jan 10 2018 06:40 AM
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.
Jan 10 2018 01:49 PM
Jan 10 2018 02:19 PM
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.
Jan 11 2018 07:24 AM
Thank you. It worked
Oct 18 2023 06:05 PM
Thank you so much ! This helped me. @SergeiBaklan
Oct 19 2023 12:40 PM
@jessbwell , you are welcome, glad to help.
Jan 26 2024 02:55 AM