trapset4
Programmer
- Oct 21, 2008
- 11
I am very new to charts in Crystal - though I produced them in Access. My x-axis data is dates. I want the 12 full weeks prior to today (preferably the Sundays).
My y-data includes Order totals for these 12 weeks.
I would also like to show our target and breakeven points.
The dates I capture through a Custom Function that finds every Sunday in the 12 preceding full weeks.
The Order Totals I capture from several tables and store in an array.
The last 2 are constants - yearly amounts that I simply divide to find weekly targets.
How can I set this chart up??
My y-data includes Order totals for these 12 weeks.
I would also like to show our target and breakeven points.
The dates I capture through a Custom Function that finds every Sunday in the 12 preceding full weeks.
The Order Totals I capture from several tables and store in an array.
The last 2 are constants - yearly amounts that I simply divide to find weekly targets.
How can I set this chart up??