Two-Level X-Axis labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
January Februar

I am thinking that there is no way to do this. Any ideas?!
 
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 said:
Let's say I have a report with a bar chart on it and the bars are
Click to expand...
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:
 
Back
Top