How to Add a Grand Average bar to an existing bar chart

Question

I want to show total average of all values in bar chart at the last column how to do this?

Answer 1

Hi Anitha,

Its easy and simple, follow below steps:

1. Create a bar chart as usual.

2. Add Grand totals from analytics pane.

3. Now click on the grand total bar and click on automatic.

4. Select average in the drop down.

5. Now a average column for the chart of all values is shown at the last column.

6. Now edit the alias name for the column/bar to average or grand avg.

Hope this helps you.