[AccessD] Charts

Roz Clarke roz.clarke at donnslaw.co.uk
Thu Jan 29 12:03:35 CST 2004


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


More information about the AccessD mailing list