Build a Chart

[jarthi]

Hi:
I already have a report built. It is quite a complicated report. Now I want to build a chart out of it. I have no clue how to do it.

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan 5 6 7 8 9 9 1 2 2 4 5 3
Projected 5 6 7 8 9 9 1 2 2 4 5 3
Actual 5 6 7 8 9 9 1 2 2 4 5 3

(I just copied the data for all 3, it will not be the same)

Now each one is a formula.
Jan Plan is one formula (max of @famt1) , Feb Plan (max of @famt2) is a seperate formula and so on...
Similarly Jan Projected is one formula (Sum of @Jan), Feb Projected(sum of @Feb) and so on..
Jan actual (sum of @JanClosed), Feb actual (sum of @FebClosed) and so on....

Now how do I plot this on a bar chart, with values on the y-axis and month on the x-axis. Each month should have 3 bars (plan,projected,actual)

Please help,

THanks,
Arthi

 

[HowardHammerman]

What happens when you try to create a standard chart in Crystal? Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269