10 Replies Latest reply on May 4, 2017 11:37 AM by Jay Morehart

# How to plot average value in the Bar graph

Hi

In the location bar graph ( As shown below), i've 3 cities let say, X ( Green), Y( Yellow), Z ( Red) - Each city assigned to below values. Now I would like to give 100,20,-100@ values to X, Y, Z cities respectively & show the average value on the bar graph - Can someone help how to get away with this.

X- 50

Y- 30

Z-20

• ###### 1. Re: How to plot average value in the Bar graph

You might be able to to this with a reference line, or a dual axis chart, Can you post a packaged workbook so we can better understand your data?

• ###### 2. Re: How to plot average value in the Bar graph

Thanks for your quick reply - Let me know if this files helps

• ###### 3. Re: How to plot average value in the Bar graph

Hi Jay, Able to get this? - Please let me know

• ###### 4. Re: How to plot average value in the Bar graph

Ok, so if you want to keep the stacked bar you have to do a calculation, and a dual axis resulting in: (workbook attached)

if you split the types out into columns you can use an average line:

• ###### 5. Re: How to plot average value in the Bar graph

Hi Jay, This helps - But few doubts What calculation have you done? I just wanted 66 value to be horizontally displayed - Is there any way that i can adjust this? - Please let me know. Thanks a lot

• ###### 6. Re: How to plot average value in the Bar graph

Jay - To specific i just wanted Avg line like in the sheet 3 should be shown without  splitting the type - Let me know if there is any way

• ###### 7. Re: How to plot average value in the Bar graph

Can we use number column to get the avg line ? - Let me know

• ###### 8. Re: How to plot average value in the Bar graph

Change the mark type to Gantt bar on the average marks card, then play around with the alignment/formatting of the mark label

• ###### 9. Re: How to plot average value in the Bar graph

Thanks Jay Got it :)

• ###### 10. Re: How to plot average value in the Bar graph

If this got it working for you, please mark the correct answer to close out the thread.

Happy tableauing!