With the data set below, I have created a Line Graph with the row source of:
The x-axis scale is set to a minor unit of 1 day and a major unit of 1 month. I want to use a minor of daily so that the line shows the variations of the value BETWEEN the major units. (which is working perfectly)
The x axis labels only show major units of the first day of each month (which is perfect).
Daily Data ( ... is edited out to cut down on length of the post)
Date AverageVal ContFigure
1-Oct-10 2269925.75 29821401.04
2-Oct-10 2290857.32 29821401.04
...
1-Nov-10 6757529.59 29821401.04
2-Nov-10 6857781.49 29821401.04
3-Nov-10 6857781.49 29821401.04
...
1-Dec-10 7138800.74 29821401.04
...
1-May-11 19093757.61 29821401.04
2-May-11 19093757.61 29821401.04
3-May-11 19093757.61 29821401.04
...
What I would like to do is progmatically set a marker and data label on the first of the month only (major axis) on both of the data series values (AverageVal and ContFigure). Currently, I'm doing it manually each month which is a bad thing.
Thanx in Advance!
Joe
Code:
Me!Graph3.RowSource = "SELECT (Format([TDate],'DD MMM YYYY')),AVG([TrendOrdVal]) AS [AverageVal],AVG([TrendCF]) AS [ContFigure] FROM [StatsCurOrdValChart] GROUP BY (Year([TDate])*12 + Month([TDate])-1),(Format([TDate],'DD MMM YYYY'));"
The x-axis scale is set to a minor unit of 1 day and a major unit of 1 month. I want to use a minor of daily so that the line shows the variations of the value BETWEEN the major units. (which is working perfectly)
The x axis labels only show major units of the first day of each month (which is perfect).
Daily Data ( ... is edited out to cut down on length of the post)
Date AverageVal ContFigure
1-Oct-10 2269925.75 29821401.04
2-Oct-10 2290857.32 29821401.04
...
1-Nov-10 6757529.59 29821401.04
2-Nov-10 6857781.49 29821401.04
3-Nov-10 6857781.49 29821401.04
...
1-Dec-10 7138800.74 29821401.04
...
1-May-11 19093757.61 29821401.04
2-May-11 19093757.61 29821401.04
3-May-11 19093757.61 29821401.04
...
What I would like to do is progmatically set a marker and data label on the first of the month only (major axis) on both of the data series values (AverageVal and ContFigure). Currently, I'm doing it manually each month which is a bad thing.
Thanx in Advance!
Joe