Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / April 2008

Tip: Looking for answers? Try searching our database.

Crosstab Query Chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pam - 24 Apr 2008 23:07 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.