Access 2007 Graphs
in [General]
|
From: Jessica on 12 May 2010 16:25 Sorry it took me a while to get back. I have figured out that I can have more than one value if I do not use the crosstab feature and was able to build a chart. My new problem is that I am pretty (99.9%) sure that my chart is about as complex as Access goes with graphing. I have been doing my homework and have been reading that I may be able to do more complex graph in Access reports using VB. Do you know if this is true? I do not want to spend a large amount of time trying to build something that will not work. Just an FYI - I need these charts to run on Access reports, not to export and use Excel as has been suggested due to Access's limited charting capability. Thank you so much for your help. -- Jessica "Duane Hookom" wrote: > Apparently this is a crosstab? Can you share the SQL view? Access charts can > display multiple datasets. > > Duane Hookom > MS Access MVP > > "Jessica" <Jessica(a)discussions.microsoft.com> wrote in message > news:A0AAB97D-85B9-4A65-990B-D58ABD288448(a)microsoft.com... > > I am trying to create a graph that has two colums for two types of data. > > Basically I want: > > > > Column 1 Column 2 Column 3 Column 4 > > Row Heading Column Heading Value Value > > > > I am wanting a line graph with two lines (one for column 3 and one for > > column 4), but Access does not want to do the graph the way I want. Any > > suggestions? > > -- > > Jessica >
From: Duane Hookom on 13 May 2010 00:25
You have total control over the graph object in Access. I typically create a similar chart in Excel. I then turn on the macro recorder and make changes to the chart. After finished making the changes, I copy the recorded code and paste it into the Access form or report and change the code a little to reference the current graph/chart in Access. -- Duane Hookom MS Access MVP "Jessica" <Jessica(a)discussions.microsoft.com> wrote in message news:D47B5B40-4C4E-43C4-ADF5-724BB313ABFB(a)microsoft.com... > Sorry it took me a while to get back. I have figured out that I can have > more than one value if I do not use the crosstab feature and was able to > build a chart. My new problem is that I am pretty (99.9%) sure that my > chart > is about as complex as Access goes with graphing. I have been doing my > homework and have been reading that I may be able to do more complex graph > in > Access reports using VB. Do you know if this is true? I do not want to > spend a large amount of time trying to build something that will not work. > > Just an FYI - I need these charts to run on Access reports, not to export > and use Excel as has been suggested due to Access's limited charting > capability. > > Thank you so much for your help. > -- > Jessica > > > "Duane Hookom" wrote: > >> Apparently this is a crosstab? Can you share the SQL view? Access charts >> can >> display multiple datasets. >> >> Duane Hookom >> MS Access MVP >> >> "Jessica" <Jessica(a)discussions.microsoft.com> wrote in message >> news:A0AAB97D-85B9-4A65-990B-D58ABD288448(a)microsoft.com... >> > I am trying to create a graph that has two colums for two types of >> > data. >> > Basically I want: >> > >> > Column 1 Column 2 Column 3 Column 4 >> > Row Heading Column Heading Value Value >> > >> > I am wanting a line graph with two lines (one for column 3 and one for >> > column 4), but Access does not want to do the graph the way I want. >> > Any >> > suggestions? >> > -- >> > Jessica >> |