Average results in Crystal Bar Charts

[lavadan]

Please help me with Crystal Charts for the following scenario:I have list of how much people earn and how much they spend for entertainment.
Name Monthly Salary Entertainment Expense
A 3000 300
B 5000 400
C 1500 200
Average 3166.66 300

I have the chart that displays Monthly salary on Y axis and Entertainment expenses on X axis for each name. It is a bar chart. But the chart does not display the Overall Average salary and entertainment expenses.Any idea how to do this or a workaround?

 

[lbass]

Please do not crosspost--one thread is sufficient. Three is overkill.

You can add trend lines to charts, and that might work.

Otherwise, you could use a command as your datasource for the chart, and using a union all, you could merge subqueries that calculate the average with the corresponding field. Once they are in the same "field", they will appear on the chart. You should add the word "average" to correspond to the Name field in the command.

-LB