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

Crystal Stepped Line Chart

I can't find a way of creating a stepped line chart in Crystal Reports.

I know I can buy a third party macro called STEPED_LINE from [3 D Graphics|http://www.threedgraphics.com/tdg/products/tools/crchart/crchart_documentation.pdf] but I am suprised I can't do it with standard Crystal reports.

I can get quite close with a Bar chart but at the end of the day it does not do the job.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2010 at 10:34 AM

    Hi Jamie,

    Here are some example PDF example files I have created to show you the problem I have.

    The First chart is a standard line chart which works fine:-

    http://www.instemcustomercenter.com/pdf/Standard%20Crystal%20Line%20Series.pdf

    The second example is a stepped line chart produced using a CRChart to demonstrate the reuired format:-

    http://www.instemcustomercenter.com/pdf/Graph%20in%20Correct%20Format%20Using%20CRChart.pdf

    The third example shows you my best attempt using standard Crystal to create a stepped line format:-

    http://www.instemcustomercenter.com/pdf/Best%20with%20Crystal%20Bar%20Chart%20Options.pdf

    You can see that the vertical lines on each side of the riser spoil it.

    Do you have any ideas?

    NB. I have not sent you any data as the problem is clearly data independent. But if you need anything else do not hesitate to ask.

    Steve

    Add a comment
    10|10000 characters needed characters exceeded

    • hey Steve,

      it would be a lot easier if the chart had a marker style that is a thin rectangle rather than a square.

      here are a couple of suggestions...

      a) remove the actual line in the line style chart...right click on the chart series > series options > line style > markers only

      or the much more painstaking way

      b) create a chart which overlays 2 near identical series with the following steps

      - create a new formula that adds .1 to your current series

      - add this new formula to your show values

      - change your current series to be transparent and the new formula series

      - change your gridlines to be inner ticks instead of the regular ones

      - if you are using multiple series in your chart then you'll have to repeat the steps for each series

      jamie

  • Posted on Oct 07, 2010 at 05:51 PM

    hi Stephen,

    from the 3dgraphics ppt that you posted a link to, are you referring to the diagram on page 20?

    if so, where are you stuck?

    the lines on the bar chart can be created by:

    1) create a new formula for a line with the value that you want...if you use the diagram as an example the formula would read "whilereadingrecords; 4.3" to create the red line

    2) put the new formula in your bar chart

    3) in preview mode right click on the new formula and choose Series Options

    4) use the Show Selected Series As menu to change the formula series to a line

    if you don't like having the markers on the chart you'll have to start by creating a line chart with no markers and then changing the desired series to bars instead.

    jw

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2010 at 09:02 AM

    Hi Jamie,

    Thanks for your reply!

    When I change the formula to a value that changes from X to Y in your step (1) on step (4) the line joining points X and Y is a diagonal (i.e. the shortest line between the two points):-

    /

    rather than a step

    _|

    Add a comment
    10|10000 characters needed characters exceeded

    • yes i realize that from the picture in the ppt. however we need to know exactly where the issue is as there is more than one component to the chart.

      - is it the Y values or y axis scale of the steps that are the issue?...affected by the show value series

      - is it the spacing of the steps (i.e. distance between the bars) that are the issue?...can be reduced to 0 in chart options > gap width

      - x axis issue? ...affected by the on change of value or even the type (regular bar vs. numeric axis)

      etc.

      @Stephen, please provide more info on exactly what you can't get to work. some of these special charts in the 3d graphics add-on can be done with a bit of effort without having to purchase the add-on.

      jw

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2010 at 06:36 PM

    So Steve,

    It looks like you are going to have to compromise if you use the crystal application to create your chart. Meanwhile you could submit a suggestion on the idea's page to add stepped line charts to Crystal Reports (link below).

    [Crystal Reports Idea Page|https://ideas.sap.com/community/products_and_solutions/crystalreports]

    Debi

    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.