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