[AccessD] Charts

Roz Clarke roz.clarke at donnslaw.co.uk
Fri Jan 30 03:11:02 CST 2004


Thanks. It looks interesting... if I can get the data link to run smoothly
I'll give it a whirl, and even if I can't manage that, it looks like I have
things to learn about using pivot tables in Excel.

-----Original Message-----
From: Hale, Jim [mailto:Jim.Hale at FleetPride.com] 
Sent: 29 January 2004 19:20
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Charts


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


More information about the AccessD mailing list