Charts and graphs for Access

[Guest]

Can anyone tell me if there is a add on program for access that displays
charts and graphs as well as excell does? thanks

 

[Rick Brandt]

Can anyone tell me if there is a add on program for access that
displays charts and graphs as well as excell does? thanks

It's the same shared chart engine in all Office apps. It's just a bit harder to
get at the design tools in Access then in Excel. Otherwise you should be able
to do any chart in Access that you can do in Excel.

 

[Guest]

Thanks for the reply.


Access charts are similar to pivot tables. I am a wiz with excel. I was just
wondering if there was any software that would provide a similar platform for
designing charts in access like using excel

 

[Rick Brandt]

Thanks for the reply.


Access charts are similar to pivot tables. I am a wiz with excel. I
was just wondering if there was any software that would provide a
similar platform for designing charts in access like using excel

Don't know what you mean by that since I've never used a pivot table. If you
create your chart on a form rather than a report and then double-click the chart
after opening the form it will open the chart designer tools where you can do
most anything you want concerning formatting the chart.

Otherwise you can link to the Access data from Excel and just create the chart
there.

 

[Craig Alexander Morrison]

PivotTables were added to Access in the 2000 version and were improved when
PivotCharts were introduced in Access 2002.

Access 2003 seems quite capable with PivotTables and PivotCharts.

I have not seen much discussion about these new tools, I suppose because
most have stuck with the Access 97 functionality even when using later
versions as most "improvements" since Access 97 seem to be flawed or killed
off prematurely ADP or timely ADO (g).

Does anyone have good or bad experiences using these tools. I have yet to
test it thoroughly but PivotChart looks a lot more useful than MS Chart as
it allows your users to play around with the Chart (select/deselect the
items in the row and column criteria) even in an MDE in runtime mode.

It also makes it easier to use either Jet or SQLS2000 data, no crosstabs.