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,263Ln(x)+29,667
in the excel simulation the equation is
y=13,458Ln(x)+18,672
- If you want an example of how to Embed an Excel spreadsheet with a chart, see https://www.youtube.com/watch?v=0Fu0FujUZVY&list=PLwIULo1M2EWvapx3zAhd3jhX_ITigxM6M at about minute 45. It is really very easy to do!
- Unfortunately Access 2007 is out of support. These are the older charts. You are likely out of luck getting any support as to why the trend line equation for logarithmic is not the same as Excel. You do not say how you are using this inside of Access. Have you considered linking to an Excel workbook and displaying that graph instead? Or exporting your data to an Excel template and updating the graph end series?
- Thank you
I don't know how to link Access to Excel.
I will try to get a last access actualization to see if solves my problem.
Thank's
- Thank you. Please confirm - are you using the new Access chart or the old charts OLE Class "Microsoft Graph Chart"? If you are using the Access chart, please show a copy of your Format tab under Chart Settings.
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....
- That worked, can you show the chart in Access too?
- Hello
- If you click Reply, then below the Reply box "Open full text editor" you should be able to attach files.
- I have send you in a massage.
>I have send you in a massage.
Might help her, but I prefer a walk after sitting in front of the computer all day.
SCNR
- Is it the Modern Line Chart? What type of trendline are you using? It would be helpful to have some data to reproduce the issue. And maybe screen prints of Access versus Excel so we could see where you see the discrepancy
- How do i send a printcreen?
- as you can clearly see, you have Different computation there?
I Don´t understand com you explian the Different computation arnel_gp
- Can you clarify which Access Chart you are using?
- Line graphic
