[AccessD] Charts

Jim,

please tell me how do you create a Pivot Table in
excel using a table in Access?!

TIA

Sander
--- "Hale, Jim" <Jim.Hale at fleetpride.com> wrote:
> You might explore using pivot charts in Excel. I
> export the data either
> manually or in code to a hidden excel worksheet. The
> chart does the hard
> work. It is very flexible. It is easier to show than
> explain so I am sending
> you an example. HTH
> Jim Hale
> 
> -----Original Message-----
> From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
> Sent: Thursday, January 29, 2004 12:04 PM
> To: 'Access Developers discussion and problem
> solving'
> Subject: RE: [AccessD] Charts
> 
> 
> Sorry Stephen, I guess I wasn't clear enough
> 
> I have the column headings set in my cross-tab query
> and that works just
> fine. The problem is when I try to base a line graph
> on that data... I just
> can't see a way to do it.
> 
> -----Original Message-----
> From: Stephen Bond
> [mailto:stephen at bondsoftware.co.nz] 
> Sent: 29 January 2004 17:34
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Charts
> 
> 
> Making an assumption here that you have a Cross-tab
> Q with the month column
> header formatted MM ...
> 
> * go to Query Properties, and put something like
> this in the 'Column
> Headings' entry: 1;2;3;4;5;6;7;8;9;10;11;12
> 
> This will force a column heading for each month.
> 
> Stephen Bond
> 
> > -----Original Message-----
> > From: Roz Clarke
> [mailto:roz.clarke at donnslaw.co.uk]
> > Sent: Friday, 30 January 2004 5:54 a.m.
> > To: 'Access Developers discussion and problem
> solving'
> > Subject: [AccessD] Charts
> > 
> > 
> > Hi all. Hope everyone is well.
> > 
> > I have a problem with a chart I need to display in
> Access. I
> > used to do this
> > by exporting data to Excel but the connection to
> Excel has 
> > been so slow and
> > unstable that I am now trying to bring it within
> Access.
> > 
> > The data I need to display is in a cross-tab
> query, where I
> > have categories
> > as the row header and months of the year as the
> column 
> > header. I need to
> > show all the months even though we currently have
> data only 
> > for January.
> > 
> > If I base the chart on the cross-tab, I cannot see
> a way to
> > tell it that
> > each column should be an axis entry. If I base the
> chart on a 
> > select query,
> > it correctly allows me to set 'month' as an axis,
> but only 
> > shows me January.
> > 
> > Can anyone help?
> > 
> > TIA
> > 
> > Roz
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> >
> http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/