View original (French)

Insert asterisks on a histogram in "excel"

Solved
manou23dz -  
Jimpix Posted messages 12079 Registration date   Status Member Last intervention   -
Hello,

I would like to insert asterisks * * in a histogram to indicate whether there are significant differences, h.s or t.h.s, compared to my data (analysis of variance), but I don't know how. Please let me know how to do this. 
Configuration: Windows XP Internet Explorer 6.0

2 answers

  1. DocPosido
     
    Ah, I found a trick!
    You right-click on the column you’re interested in (the one where you want an asterisk to appear), click on "Format Data Label." In the "Label Options" tab, you select, for example, "Value" (or something else, the important thing is that something appears in your column). You close it, and then you click on the value that appeared in your column and replace that value with an asterisk or 2 (for different levels of significance). It’s a bit of a hack, but it works! :-)
    17
    1. M
       
      You insert a text box and type the asterisk yourself :-)
      1
    2. Jimpix Posted messages 12079 Registration date   Status Member Last intervention   4 391
       
      Since 2008 ????
      0
  2. DocPosido
     
    I have the same problem... I don't know how to put asterisks above the columns of my histogram...
    If anyone knows how to do it, please respond :-)
    Thank you
    2