Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Graphing

Status
Not open for further replies.

kriesten

Technical User
Apr 16, 2001
13
US
Crystal 8.5, Oracle database, WindowsXP

I had a issue similar to 'Stop Graph/Chart Colors from changing each time I run.' from JHear1. It's hard to describe this so bear with me.

I have a line chart that will show 5 different issues that come up

Data Group1 = @Status
Data Group2 = grouped by 'Problem Description'

The data selection for the chart is as follows:

For each @Status ('Completed', 'Not Completed')
On change of 'begining_date' - order is for each week
Show value Count of '@Problem 1'
Count of '@Problem 2'
Count of '@Problem 3'
Count of '@Problem 4'
Count of '@Problem 5'

What is happening is the graph is totaling up all the @Problems for each period on one line the last Problem code (@Problem 5) is the only color that is shown.

I was trying to get the colors to stay the same as well when refreshing without having to go through the Chart Analyzer and modifying it each time.

Previously the chart data was set up as such

For each @Status ('Completed', 'Not Completed')
On change of 'begining_date' - order is for each week
and 'Problem_Desc' - In specified order
Show value Count of 'Probelm_code'

I am not sure what the color selection is dependent on, but it changes for each @Status grouping.

Any help would surely be welcome.

Looking forward to using XI eventually for new enhancements.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top