Crystal Report Bar Graph Options

[Former Member]

Hello everyone,

I'm an user of old version of Crystal but have recently downloaded the demo version of Crystal Report 2013.

I'm looking for a way to include a horizontal "baseline" line to a sample bar graph that I've designed. This baseline is suppose to be like a target dollar amount to measure each monthly bar to see whether it has exceeded the target.

However, I cannot find this option anywhere on Chart Expert or the Templates.

Does such an option exist in Crystal Report? And if so, how do I find it and use it?

Thank you kindly,

[abhilash_kumar · Accepted solution]

Hi Frank,

Highlight one of the Y-axis values > Right-click > Data (Y) axis options > Gridlines > Check 'Draw Customer Line at:' > Type in a value.

-Abhilash

[Former Member · Accepted solution]

Hello and thank you!

I also meant to add that the target line needs to be pulled from the database along with the values for the bar. Is that possible?

Thank you kindly,

[abhilash_kumar · Accepted solution]

Yes it is. Here's how:

1) Create a formula with this code:

Maximum({dollar_amount_field})

2) Go to the Chart Expert > Type > Select 'Line'

3) Move over to the Data tab > Add the formula from step 1 to the 'Show Values' section. So, you'd now have two fields in this section

4) Refresh the report > You should see two lines. One is a straight horizontal line which is the 'baseline' and the other is the measure field you already had > Highlight this line (not the baseline) > Right-click > Series Options > From the drop down for 'Selected Series', choose 'Riser'.

Hope this helps.

-Abhilash

[Former Member · Accepted solution]

Thank you! I assume this works for the bar graphs as well?

Thanks again,

[abhilash_kumar · Accepted solution]

No! You'd need to convert the chart type to line graph > Convert one of those lines back to Riser.

-Abhilash

[Former Member · Accepted solution]

I understand. Thank you very much!