3

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,

Mahendra Gunawardena
  • 7,153
  • 5
  • 25
  • 65
Cindy.Karina9
  • 187
  • 1
  • 13
  • 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. – Solar Mike Jan 31 '18 at 08:41
  • 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.. – Cindy.Karina9 Jan 31 '18 at 08:45
  • 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. – Solar Mike Jan 31 '18 at 08:59
  • 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 :) :) – Solar Mike Feb 01 '18 at 06:10
  • Thank you very much Solar mike!! I really appreciate it!! – Cindy.Karina9 Feb 01 '18 at 06:45

1 Answers1

3

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.

Carl Witthoft
  • 4,180
  • 1
  • 12
  • 13
  • Thank you Carl Witthoft.. It is solved already.. thank you alot, I really appreciate it – Cindy.Karina9 Feb 01 '18 at 06:46
  • 1
    Or the up-and-coming [Julia](https://julialang.org) language with some world-class scientific applications [here](https://juliacomputing.com). – AsymLabs Feb 01 '18 at 20:17