8 Replies Latest reply on Sep 10, 2017 2:00 PM by Rajesh Avula

# Error Bars in Tableau

Can we Create Error Bars in Tableau with Mean and Standard Deviation Like we do in excel.

• ###### 1. Re: Error Bars in Tableau

Hi Rajesh,

Did you evaluate "Box and Whisker plot" in Tableau.

Regards,

Norbert

• ###### 2. Re: Error Bars in Tableau

I have seen the Box and whiskers plots. I am attaching an excel sheet. In my case there are two averages ([Priority, m] and [Value, m]) and two standard Deviations ([Priority, s] and [Value, s]). so there will be two worksheets where.

Worksheet 1: [Priority, m] vs[Priority, s] where i will keep [Ideas] Dimension in the colors of marks card.

Worksheet 1: [Value, m] vs[Value, s] where i will keep [Ideas] Dimension in the colors of marks card.

I tried with box and whisker but i am not getting the desired view ( I want a chart where the center point should be mean and whiskers should be standard deviation.). It would be great if you go through my excel and see how to achieve it. Thanks,

• ###### 3. Re: Error Bars in Tableau

Hi Rajesh,

Regards,

Norbert

• ###### 4. Re: Error Bars in Tableau

yes the above pivot table is absolutely correct

• ###### 5. Re: Error Bars in Tableau

If possible can you attach the workbook how did you do the "box and whisker plots" for the mean and standard devation for above pivotted data

• ###### 6. Re: Error Bars in Tableau

Hi Rajesh,

Find my approach attached. Please validate

Regards,

Norbert

• ###### 7. Re: Error Bars in Tableau

Hi  Rajesh

it's there in the original thread. Leaf your inbox and go to the original post

Regards,

Norbert

• ###### 8. Re: Error Bars in Tableau

Thanks for helping me. Thats is what I am looking for. Can we do in a different way

Instead of two worksheets can we combine two worksheets into single one. By keeping

1)  AVG[Value, m] in Rows,

2)  AVG[Priority, m] in columns

3)  [Idea] to the color in Mark card.

4)  AVG([top]),  AVG([top Value]),  AVG([bottom]),  AVG([bottom Value]) to the tool tip.

I am looking for a result like this where each circle has both Priority and value Reference bands. Thanks.