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

Format for Line Graph

Status
Not open for further replies.

MBNelsonCR

IS-IT--Management
Mar 24, 2002
17
0
0
US
Crystal Reports 9.0

I am pulling data from an Access 2002 Query. The data is calculated (In Access) to show percentages for a given time period (Current, -1Month, -2Months, -3Months, etc.). I would like to display my data in a line graphs as follows:

100% x
75% x
50% x
25% x x
0% x x
Current -1 -2 -3 -4 -5 -6
Month (Apr, Mar, Feb, Jan, etc)

However I am getting this:

100% x
75% x -2
50% x -1
25% x Cur
0% x -3

Where all of the values are showing up in a single column. I have looked at the different settings for the charts but I am unable to get it to display the way I want it to. Any ideas?

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top