Print Page | Close Window

Create chart from two values

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21455
Printed Date: 04 May 2024 at 1:06pm


Topic: Create chart from two values
Posted By: rlassalle
Subject: Create chart from two values
Date Posted: 27 Apr 2015 at 5:37pm
I would like to create a bar chart from this report source;
Monthly        BBB    OCC    CFPB
2014-12          1      2      2
2014-11          4      1      2
2014-10          2      1      1
Other month…………………………
12 Mnth AVG     1.5    5.8    7.4

I have 12 months and the summary in the detail section.
The chart has to have the last months which is not included in the summary I filter 2015-01 to got that. But, the values has to be part of the chart. Just the current month in this case 2015-01 and the summary for the avg. have to be the values in the chart. I did an e.g. in excel. I would like to do the same in Crystal.

          
SOURCE      Current Month     12MnthAVG
BBB         0               1.7
CFPB         10               7.2
OCC         5               5.9

Sorry, I tried to paste the chart;but, I can't

You will figure it out
Thank for you help in advance

Rodolfo




          
          
          
          
          
          
          
          
          
          











Print Page | Close Window