Terence,
I typically create a similar chart in Excel. Turn on the macro recorder and make your changes to the X Axis interval. Then turn off the recorder and find the code. You should be able to use nearly the same code in Access.
Duane Hookom MVP
MS Access
From: buffalome000@yahoo.com
Date: Thu, 27 Feb 2014 11:41:05 -0800
Subject: [MS_AccessPros] graph object ms access 2007
Can someone please helk me with syntax to appropriatley get to (and change) the
X Axis interval to a 1.
I just can't seem to get it correct.
below is an example of a line I use to toggel the legend for my graph.
Me.Graph94.Object.Application.Chart.haslegend = False
I thought it would look something like below:
xlCategory = 1
Dim GraphObj As Object
Set GraphObj = Me![Graph94].Object.Application.Chart
GraphObj.axes(xlCategory).interval = 1
Terence
I typically create a similar chart in Excel. Turn on the macro recorder and make your changes to the X Axis interval. Then turn off the recorder and find the code. You should be able to use nearly the same code in Access.
Duane Hookom MVP
MS Access
From: buffalome000@yahoo.com
Date: Thu, 27 Feb 2014 11:41:05 -0800
Subject: [MS_AccessPros] graph object ms access 2007
Can someone please helk me with syntax to appropriatley get to (and change) the
X Axis interval to a 1.
I just can't seem to get it correct.
below is an example of a line I use to toggel the legend for my graph.
Me.Graph94.Object.Application.Chart.haslegend = False
I thought it would look something like below:
xlCategory = 1
Dim GraphObj As Object
Set GraphObj = Me![Graph94].Object.Application.Chart
GraphObj.axes(xlCategory).interval = 1
Terence
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar