Bar Chart with Goal Line 2

[GCL2007]

I'm using Crystal XI trying to reproduce some charts that are currently created using a different software. I have a bar chart with Quarterly buckets (Q1, Q2, Q3, Q4) at the base of the chart with vertical bars signifying $'s. That part is fine, however in addition to the bars on the same chart, they want to put a horizontal goal line on the same chart signifying the quarterly $'s in goals. Right now, I have no idea how I am going to pull the data for this goal line, as it is not in a database anywhere. My question is it even possible to mix a standard bar chart with a line chart superimposed on top of it? I don't expect the goal numbers to change - is there a way I can even dummy this in Crystal graphs? Thanks....

 

[IdoMillet]

Yes. 2 Options:

1. to create a static goal line: select the Y axis, Right-click, Data (Y) Axis Options, Gridlines Tab, ‘Draw Custom Line at’… To format the line, select it and Right-Click…

2. to draw a dynamic goal line. add it as a second series,
select one of the bars from the "goal" series.
Right-click and select 'Series Options..."
change the "Show Selected Series As:"
from "default for Chart Type" to your choice ("Line" or "Area")

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Create a formula {@Goal} like this, replacing the numbers with your quarterly goals:

select datepart("q",{table.date})
case 1 : 200000 //qtr 1 goal
case 2 : 100000
case 3 : 400000
case 4 : 300000
default: 300000

Add this as a second summary field, and use maximum as the summary. In Chart Options->legend, change the color to "color by series". Then in preview mode, select one of the goal risers->right click->series options->appearance->show selected series as: line.

Of course this depends upon your version of CR which you should always identify.

-LB

 

[GCL2007]

Thank you guys.. That worked out great..