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
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