Insert asterisks on a histogram in "excel"
Solved
manou23dz
-
Jimpix Posted messages 12079 Registration date Status Membre Last intervention -
Jimpix Posted messages 12079 Registration date Status Membre 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.
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 réponses
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! :-)
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! :-)
M
You insert a text box and type the asterisk yourself :-)
Jimpix
Posted messages
12079
Registration date
Status
Membre
Last intervention
4 389
Since 2008 ????