Avatar of Clif
Clif
Flag for United States of America asked on

Graph - How Do I???

I need a graph similar to this:
ExampleObviously there are eight columns, two for each quarter.  Each of the two columns for each quarter represents two years (2011 and 2012).  Each column represents two values, Income (yellow) and Expense (Cyan)

In the Chart Expert, I select 'For each record' to be year and 'Show Values' of Income and Expense.

I can get a single set of two columns (any particular quarter), but how do I get all quarters to show up as in the example graph?

My query currently returns Year, Value Type (I = income, E = expense) and the values for each month which I calculate to give me the values per quarter.  So, I might have two records that return values such as this:
Year   Type   January   February   March     April
2011     I    600000    650000     500000    450000
2012     I    800000	900000     550000    600000
2011     E    800000	900000     900000    1000000
2012     E    900000	1000000    14000000  1000000

Open in new window

(Only showing to April 'cause I got tired of typing, but you get the idea)

I can modify the query if needed.

Hopefully I got my needs across.  :)

TIA
Crystal Reports

Avatar of undefined
Last Comment
James0628

8/22/2022 - Mon
Mike McCracken

WHen you put the fields on the chart, you can set the "time frame".

Open the report
Right click the chart
CLick CHART EXPERT
Select the date field in the box
CLick CHANGE GROUP OPTIONS
Set the time to be QUARTER

mlmcc
Clif

ASKER
mlmcc,

I'm not quite following...

What date field?  In which box?

There are no "group options" available that I can see.  In the Data Tab there is a frame named "Layout" which has several buttons, all disabled except for "Advanced" which is currently selected.  One of the disabled options is "Group" but I do not know how to enable it.
GJParker

I'm prettry sure this is not possible using your data structure and teh standard CR charts
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Clif

ASKER
GJParker,

Fair enough.  So how do I need to change the data structure (or how do I use "non-standard" CR charts)?
GJParker

First step is to see if there is a chart available that does what you need, You can purchase add on charts here http://www.threedgraphics.com/tdg/products/tools/crchart/product_info.php

Only then will you knwo what format the data needs to be in
Clif

ASKER
GJParker,
While the graphs from Three D Graphics look pretty cool, I'm not quite ready to plop down $1500 for one chart that may only be used one time.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
James0628

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Clif

ASKER
I ended up using a different (line) chart.  But the recommendation to seperate the quarters in the records (one record for each quarter) made life just a little easier.

Thanks.
James0628

You're welcome.  Glad I could help.

 James