Advanced charts. Excel vs Access

[Fuga]

Hi.

I need to display statistical data in charts. The fundamental data comes from a table in access. Then excel makes the statistical calculations. Now I´m thinking of adding a function to the db that imports back the calculated table to access, so that I can use it in there again. But should I really do so?

From what I understand, the charting possibilities are far greater in excel than in access, but is this true? I would have thought that the office programs uses the same addins for those things.

Is there a way to code charts in access so that they display what I want?

Fuga.

 

[llkhoutx]

My understanding is that the Excel Chart function is superior to that of Access.

The only real difference that I have actual knowledge of is that Excel can chart more parameters than Access.

 

[Fuga]

Thanks.

Yes, that´s my experience too. Guess I´ll use excel a while longer.

Fuga

 

[The_Doc_Man]

The problem is sort of two-fold.

If you work from Access, the wizard won't let you do certain things that you might really like to do. (Because wizards have to make assumptions.) The Excel wizard assumes less, so lets you do more.

On the other hand, the Access problem is exacerbated by the little bug that hits AC97 and AC2K that causes the chart to initially display data from the example database. Of course, there is a knowledge-base workaround for that, but the problem never occurs in Excel.

So, overall, despite the greater smarts of Access vs. Excel, I have to say that Excel does charts better.

 

[Paul_B]

I had the same problem and overcame it by creating the charts in Excel (so much better/easier) then linking the actual excel worksheet - not the chart - back into an Access report.

Insert the Excel object etc, then you select the source doc (name and path of the excel file) also make sure you set the source item to either a defined excel name or just the print area ie set Source item = Sheet1!Print_Area

Paul.

 

[Thales750]

Can we revisit this folks?