Crosstab Query Chart

[Pam]

Hi,

I'm not sure if this is the correct place to place my request for help, but
hopefully someone can help or steer me in the right direction.

I have the following crosstab query I am trying to create a chart for. I've
tried in Excel, but can't get it to accept multiple x axis.
Sheet1_Crosstab Head (ft) Efficiency Power Pressure Temperature CR 20 40
60 80
113 7.2 18 9.4 26 2.7
2


238 7.7 20 8.8 28 2.6

3

241 7 16 9.7 26 2.8 1



514 6.9 232 7.8 26 2.4


4

The columns 20-40-60-80 are "Flow" and 1-2-3-4 beneath the flow are "data
points".

I need a line chart set up this way with Flow at the bottom for x axis and
each of the data points as points on chart. Head, Efficiency, Power,
Pressure, Temperature and CR should be y axis on left of chart.

Is this possible from a crosstab query?
If any can help, it will be greatly appreciated.
Thanks in advance.
Pam

 

[Evi]

I haven't heard of a chart that Access can do but Excel can't. - it's
usually the other way around. Have you asked at the Excel newsgroup?
Evi

 

[PHisaw]

Evi,
The Excel newsgroup was my first stop - I searched posts and the only thing
I could find for multiple "x" axis was one on the left and one on the right.
I need six "x" axis on the left side. Since I have this in a crosstab query
I thought I would keep it in Access.
Sheet1_Crosstab
Head (ft) Efficiency Power Pressure Temperature CR 20 40 60 80
113 7.2 18 9.4 26 2.7 2
238 7.7 20 8.8 28 2.6 3
241 7 16 9.7 26 2.8 1
514 6.9 32 7.8 26 2.4
4

The columns 20-40-60-80 are "Flow" and 1-2-3-4 beneath the flow are "data
points".

Thanks,
Pam