3
$\begingroup$

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,

$\endgroup$
  • $\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 Jan 31 '18 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$ – Cindy.Karina9 Jan 31 '18 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 Jan 31 '18 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 Feb 1 '18 at 6:10
  • $\begingroup$ Thank you very much Solar mike!! I really appreciate it!! $\endgroup$ – Cindy.Karina9 Feb 1 '18 at 6:45
3
$\begingroup$

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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