Forum Discussion
Access automatic calculation is wrong
Hello I have a grafic with a tendence line but the grafic is wrong This is my case: I have a grafic with a tendence line but the grafi worg X Y 2 29,9 28 64.4 y=16,...
HI MariaBarnes
I Treid to upload more fotos but it`nt possible.
I attach a word doc, with the step`s of the graphic creation on access 2007.
Sorry for the inconvenience, I'm not a programmer. I have no training in programming, this program was created by me, according to my needs and exploring the functionality of access as a user. Thank you for your attention and availability.
Many times over the course of my career I found the approach Maria suggests to be the better choice. If Excel charts are superior, then using Excel charts makes complete sense.
Typically what I did was create a template in Excel with TWO worksheets (or more, depending on the situation). The first is the formatted "presentation" Worksheet with graphics and other formatting in place. The second is the "landing page" for data exported from Access. The presentation worksheet is linked to the corresponding ranges in the data in the landing page.
In one case, it's worked well for nearly a dozen years....
Typically what I did was create a template in Excel with TWO worksheets (or more, depending on the situation). The first is the formatted "presentation" Worksheet with graphics and other formatting in place. The second is the "landing page" for data exported from Access. The presentation worksheet is linked to the corresponding ranges in the data in the landing page.
In one case, it's worked well for nearly a dozen years....
- Thank you<br /><br />I don't know how to link Access to Excel.<br />I will try to get a last access actualization to see if solves my problem.<br /><br />Thank's