Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Graph: Set Data Marker and Label at Major Tick Marks

Status
Not open for further replies.

joebb3

Programmer
Feb 27, 2006
87
US
With the data set below, I have created a Line Graph with the row source of:

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top