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

Can CRXI or Xcelsius do this with a chart axis?

Status
Not open for further replies.

mgason

Technical User
Feb 6, 2003
158
AU
Hi,
I need to control a bar chart X axis in a specific way.
I am wondering if this is in any way possible using crystal reports 11.
Could formulas somehow control the axis, or massage the data to get the result below?
If the answer is a definite NO then does anyone know if Xcelsius could achieve this?

My database holds information about weighments made at a machine
My database contains the following items in various tables, I am placing some hypothetical values before them...
3 pounds -Setpoint (the target weight)
0.2 pounds -Tolerance (weight variation that is acceptable)
0.01 pounds - Scale Accuracy

of course all of these change depending on the material

Also it includes actual weighments, which I need to display a count of for each weight, hypothetical values below

Weight Count
2.00lbs 1
2.70lbs 1
2.80lbs 2
2.82lbs 5
2.88lbs 15
3.00lbs 50
3.02lbs 20
3.03lbs 3
3.04lbs 2
7.00lbs 1

My Charts X axis would need to display all divisions of scale accuracy between the Setpoint - (2 x Tolerance) and Setpoint +(2 x Tolerance) and chart the weights in that range.
It also charts any weights that fall outside that range as individual points without including all the scale accuracy divisions, as in the 2lb and 7lb weighments.

So the chart for the above data would have an X axis with a point marked at 2.0, then right next to that a point marked 2.6 from there points at every 0.01, eg. 2.61, 2.62, 2.63 all the way to 3.4, then right next to 3.4 would be point marked 7.0.

Can I control the marking of the axis in detail this way with this data?
If this is unclear I have put a rough drawing of the resulting chart at

thanks in advance for any advice
mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top