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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying 2 line cahrts

Status
Not open for further replies.

syncdba

IS-IT--Management
Nov 28, 2005
206
US
Hi,
I have CRXI. I have create a report which has 2 line charts. 1.Amount 2.Revenue. First they were 2 different charts. With x-axis "Sum of amount/revenue in USD" & y-axis as"Months"
Before putting both charts together y=axis is Aug05,sept05,Oct05,Nov05....June06,July06.I have this as Specified order in Group BY.It was working fine But when I joined both reports(Amount & Revenue)& selected charts,then advance & "Onchange"I selected month & "Summation of Amount" & "Summation of Revenue" in "showdata"
The y-axis is changed It is coming as "April06,Aug05,Dec05,feb06,Jan06,..in ascorder.
How can I change the y-axis as before "aug05,sept05,oct05,nov....july06. Specified order is same as before is created.
 
In the chart expert, you should be able to select your "on change of" field ->Order->select "specified order" and add the months in chronological order. Just as it sounds like you did before.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top