2 Replies Latest reply: Mar 21, 2013 10:20 AM by Jerrold Green1
Valliance Level 1 Level 1 (0 points)

Hi,

 

Is it possible for me to have different standard errors in a column graph? (i.e. in a graph with 2 or more columns/bar to have their individual error bars drawn out?) So far I have only been able to have a single number for both columns in the graph.

 

V

  • 1. Re: Standard error of mean for column/bar graphs
    Wayne Contello Level 6 Level 6 (13,615 points)

    You can superimpose multiple charts... one with the error bard set with one value, then another chart  with error bars set to another

  • 2. Re: Standard error of mean for column/bar graphs
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    V,

     

    Numbers does the best it can with the information you give it. If you ask for Error Bars, Numbers will calculate the standard deviation for the series and assign that calculation result to each of the bars in the series.

     

    If each of your values represents some statistic that in itself is accompanied by a standard error, that's another thing, but Numbers doesn't know what the error values are unless you tell it. The way to tell Numbers what the error bar values should be in these special cases is to use Custom values.

     

    Here's an example:

    Screen Shot 2013-03-21 at 1.16.00 pm.png

    I like to use the Scatter Chart, but you will find similar controls for the bar chart.

     

    Jerry