J
Jim
I am using Access 97 and trying to create some charts. I
can get most of what I need accomplished however, two
things I need help with. I need to change the name of the
chart series programatically. The chart automatically
assigns the name to the grouping option of the Rowsource
(for example SumOfHoursLeft). I need to be able to set
this to a variable used in the report code. Neither my
work computer or my home computer is able to reference
the MS Graph Help file (I follow the procedures given to
install this but they never work), so I can't figure out
the proper programming syntax to make this happen.
The second problem I have is that the date field which is
being plotted on the X axis is sorting data by the Text
format of the date, so that 10/24/03 is showing up before
9/21/03. The value being plotted is:
Expr1:Format([Date],"ddddd").
Any help will be greatly appreciated.
can get most of what I need accomplished however, two
things I need help with. I need to change the name of the
chart series programatically. The chart automatically
assigns the name to the grouping option of the Rowsource
(for example SumOfHoursLeft). I need to be able to set
this to a variable used in the report code. Neither my
work computer or my home computer is able to reference
the MS Graph Help file (I follow the procedures given to
install this but they never work), so I can't figure out
the proper programming syntax to make this happen.
The second problem I have is that the date field which is
being plotted on the X axis is sorting data by the Text
format of the date, so that 10/24/03 is showing up before
9/21/03. The value being plotted is:
Expr1:Format([Date],"ddddd").
Any help will be greatly appreciated.