[AccessD] Charts

Stephen Bond stephen at bondsoftware.co.nz
Thu Jan 29 13:43:47 CST 2004


I see what you're up against - I've never been a fan of Access charts ..... Excel always <uh> excels ....

I had a bit of a play, I'm afraid my approach has overtones of sledgehammer, but tell me what you think:

I created a new local table called tblMasterMonths, one field called MM, type number (byte).  Filled the table with 12 records, values 1, 2, 3, ... 12.

To build the query underlying the Chart, I took the select query I had (the one that only shows me January) and altered it to include tblMasterMonths, with a Left Join from tblmasterMonths to the query that contains the raw data.  This forces months with no data to still have an entry in the output.

Use the output from this into the Chart.

Stephen Bond


> -----Original Message-----
> From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
> Sent: Friday, 30 January 2004 7:04 a.m.
> 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
> 


More information about the AccessD mailing list