on 2015 Oct 16 11:21 PM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
73 | |
10 | |
9 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.