enter image description here

I want to have a star dot above each bar chart. I don't know how to present that index. Please anyone help me to resolve this problem,

  • $\begingroup$ Create a dummy data set and set its point as a star dot. Stack overflow may be better for excel questions as it is not statistics really. $\endgroup$
    – Solar Mike
    Commented Jan 31, 2018 at 8:41
  • $\begingroup$ What kind of dummy data should be added? And how to set a star dot? I am really still fuzzy in this matter, if you dont mind to give me more explanation.. $\endgroup$ Commented Jan 31, 2018 at 8:45
  • $\begingroup$ Use the add data function, x values you already have, y values can be zero or 1 or whatever value to get the stardot where you need it - but make the data line blank so it is not seen. $\endgroup$
    – Solar Mike
    Commented Jan 31, 2018 at 8:59
  • $\begingroup$ Another trick is to make a second chart which is transparent except for the data and lay it on top of the first - did that once - what looked like a single chart was actually six - the people trying to steal the work were tearing thier hair out as they couldn’t get their chart to work :) :) $\endgroup$
    – Solar Mike
    Commented Feb 1, 2018 at 6:10
  • $\begingroup$ Thank you very much Solar mike!! I really appreciate it!! $\endgroup$ Commented Feb 1, 2018 at 6:45

1 Answer 1


Quite seriously: Friend Don't Let Friends Use Excel. Learn to use Matlab/Octave, or python, or R, or just plain Gnuplot.
No matter what tool you use, since "significance" is a separate variable, you need to convert your collection of "*" , "**" etc to numeric values and plot the desired symbols at the matching category locations.

  • $\begingroup$ Thank you Carl Witthoft.. It is solved already.. thank you alot, I really appreciate it $\endgroup$ Commented Feb 1, 2018 at 6:46
  • 1
    $\begingroup$ Or the up-and-coming Julia language with some world-class scientific applications here. $\endgroup$
    – AsymLabs
    Commented Feb 1, 2018 at 20:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.