T
Tom
I want to create a "comparative histogram" in an Access report...
Let's say I have the following data in a query:
1 Above 227
1 Below -57
2 Above 114
2 Below -81
3 Above 2
4 Above 6
4 Below -5
- I have 4 objectives (1:4); most times, histograms compare "Male" vs.
"Female" or "Pro" vs. "Con"... this is not really the case for me; here I'm
simply measuring how many records fall above/below a line.
- I want the graph to use an axis of "0" (breakline).
- Now I want 4 boxes (those of "Above" category) on top the axis and 4 boxes
below the axis (those of "Below" category)
- The top boxes in graph show values: 227; 114; 2; 6
- The below boxes in graph show values: 57; 81; ---; 5
Does anyone know how to create a graph/chart like this?
Tom
P.S. Maybe a picture (PlusMinus.jpg) will help. The proportions are not
proper but the image should get the idea across.
http://tombock2004.i8.com/Test
Let's say I have the following data in a query:
1 Above 227
1 Below -57
2 Above 114
2 Below -81
3 Above 2
4 Above 6
4 Below -5
- I have 4 objectives (1:4); most times, histograms compare "Male" vs.
"Female" or "Pro" vs. "Con"... this is not really the case for me; here I'm
simply measuring how many records fall above/below a line.
- I want the graph to use an axis of "0" (breakline).
- Now I want 4 boxes (those of "Above" category) on top the axis and 4 boxes
below the axis (those of "Below" category)
- The top boxes in graph show values: 227; 114; 2; 6
- The below boxes in graph show values: 57; 81; ---; 5
Does anyone know how to create a graph/chart like this?
Tom
P.S. Maybe a picture (PlusMinus.jpg) will help. The proportions are not
proper but the image should get the idea across.
http://tombock2004.i8.com/Test