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 - 25 Apr 2008 00:16 GMT
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
> Hi,
>
[quoted text clipped - 29 lines]
> Thanks in advance.
> Pam
PHisaw - 25 Apr 2008 03:01 GMT
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
> 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?
[quoted text clipped - 35 lines]
> > Thanks in advance.
> > Pam