Another chart question...

[rodbac]

Thanks, Ken, for your previous help on charting on days that aren't in the db. I will give your suggestion a try...

I also need to create a fixed line on a chart to show the 'expected/planned' values (to be compared to the actual values which will also be on the same chart). This one has me stuck, also, and the support line at crystaldecisions.com was no help.

Once again, TIA! -rodbac

 

[kenhamady]

Where do the values for the line points come from? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[rodbac]

The actual values (counts of ideas entered worldwide) will come from the db.
I don't know where the values for the fixed line (goals) should come from (I have the values in an Excel table - maybe I will just have to create another table in the database?)...

 

[kenhamady]

I am not sure what you mean by fixed.
You could try to hardcode constants into the report, but CR doesn't like to graph constants.

It will be easier to chart data that comes from a table. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.