View original (French)

Adding percentages to a histogram

Lise78 -  
 Lise78 -
Hello,

I created a pivot table and made a histogram chart. I wanted to know if it's possible to add the percentage of the column above the bars.
I saw on forums that there was a method with code, but I don’t want to do that because I’m a novice in coding. However, if the answer must involve code, I'd appreciate it if you could explain the procedure, please.

Thank you
Configuration: Windows XP Internet Explorer 6.0

1 answer

  1. relomydie
     
    Hello,

    Yes, it's possible.
    Once you've created your chart, click on the bars of the histogram and in the "data labels" tab, check values.
    Once that's done, you can select the value and place it wherever you want.

    See you +
    -4
    1. Lise78
       
      Hello relomydie,

      I tried this method but what I forgot to mention is that on the x-axis I have categories (apples, pears, etc.) and on the y-axis the corresponding amounts, and I would like to display on my graph:
      y-axis: the amounts
      x-axis: the categories
      and on the bars: the percentage of each column compared to the total amounts of the categories

      I hope I have been clearer ^^

      And thank you for responding so quickly.
      0