Skip to Content
author's profile photo Former Member
Former Member

Creating a "Average" Line on a Chart

I'm using Crystal Reports XI

I have a chart such as this (modified as an example):

What I need is to be able to add the green line as shown. Basically the line is to be located at the average/mean point (86.97. in this case).

Can I do this? How?

TIA

SCN8.png (14.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 13, 2012 at 07:29 PM

    Hi Clifton,

    The only way I was able to do this was like this:

    1) Change your chart type to "Line Chart" first

    2) Create a formula for average. Something like this:

    Average({database_field})

    3) Add this field to the Show Values area. So, the Show values will now have two values, one being the Sum and the other being this formula that shows the average

    4) Preview the report and while in the Preview Mode, select the Line that shows the Summary Values. You might have a little trouble clicking on the single line, but that shouldn't be a problem as such

    5) After you've managed to highlight the Summary Line in the Chart, right-click it and select "Series Options" > Appearance tab > From the drop-down for 'Selected series' choose "Riser"

    There you have it, Bars for the Sum and a Line for the Average.

    - Abhilash

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.