A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Two-Level X-Axis labels



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2004, 07:11 AM
BobRoyAce
external usenet poster
 
Posts: n/a
Default Two-Level X-Axis labels

Let's say I have a report with a bar chart on it and the bars are displaying data summed up by week # in the year (e.g. 1, 2, 3, 4, 5, 6, etc.). Now, let's further suppose that I want the week # to show below each bar (not a problem to do by itself...currently doing this) AND I want the MONTH associated with each group of weeks to show below that. For example, let's say that week #'s 1 thru 5 are associated with January, 6-9 are associated with February, etc. Now I want to display something like the following:

1 2 3 4 5 6 7 8 9
January February

I am thinking that there is no way to do this. Any ideas?!
  #2  
Old May 18th, 2004, 08:31 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Two-Level X-Axis labels

You can do anything you want with some code in reports using the Line and
Print methods. There are some samples in the Corp Tech Demos at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

--
Duane Hookom
MS Access MVP


"BobRoyAce" wrote in message
...
Let's say I have a report with a bar chart on it and the bars are

displaying data summed up by week # in the year (e.g. 1, 2, 3, 4, 5, 6,
etc.). Now, let's further suppose that I want the week # to show below each
bar (not a problem to do by itself...currently doing this) AND I want the
MONTH associated with each group of weeks to show below that. For example,
let's say that week #'s 1 thru 5 are associated with January, 6-9 are
associated with February, etc. Now I want to display something like the
following:

1 2 3 4 5 6 7 8

9
January February

I am thinking that there is no way to do this. Any ideas?!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.