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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|