Need help with charts

[zamboni1199]

Hi - I have a simple report with 3 columns as shown below:

Column 1     Column 2     Column 3

        7                        3                        6

        4                       9                         3

        2                       5                         4

I need to average each column and then show all 3 averages in one single bar chart (so this bar chart would have 3 different bars, each showing the average of it's respective column).  Problem is, I can create 3 separate charts, but don't know how to combine all the bars in just one chart.

Thank you in advance for your help!

[hthota]

Hi please use the Clustered Coulmn Chart.

It would help you.

[zamboni1199]

thank you.

[zamboni1199 · Accepted solution]

Ok, just figured it out.  Had to move all 3 fields into the "Value" section of the chart area.

Thanks anyway!