Access 2016 Chart/Graph Sizing issue

Posted on 2016-09-07
Last Modified: 2016-11-17
I am migrating an established Access 2010 database to a new computer and to Office365 Access.  The new computer is the 64bit Core i7 Surface Pro 4.  I have numerous Graphs in this database which all refuse to display larger than 1/4 their frame size.  I am currently unable to try this database on any other machine which is also running the latest Office365 Access, so I'm not sure if it is the graphics card or the new Access version.
With a right click in the graph design view, I have tried everything I can think of with "Chart Object"/ Edit.Graph Size is A Quarter of Frame Size
Question by:DAY 3
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
  • 2
LVL 36

Expert Comment

ID: 41788601
Since the graph is displaying, I would say it is the graphics card.

Author Comment

by:DAY 3
ID: 41788620
Thanks Pat for helping to confirm my suspicion about graphics card.  So now, what is a solution to this problem, without affecting the chart performance on other computers?  This database will eventually be used on multiple devices; laptops and tablets like this Surface.
The Charts will not only be dynamically generated in the Forms, but also in Reports and converted to PDF.

Author Comment

by:DAY 3
ID: 41788655
So if this Microsoft computer can’t properly display the basic graphs developed with Microsoft software… is there a different hardware question section of Experts here?  I would be very grateful to solve this problem somehow.
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

LVL 36

Assisted Solution

PatHartman earned 500 total points
ID: 41788689
Does Excel have the same problem?  If not, you might have to embed Excel Graphs on your Access forms and reports.  I don't have a surface pro so I can't test the theory.

Author Comment

by:DAY 3
ID: 41788853
Excel graphs work perfectly within Excel.
I have resisted using embedded Excel in these forms, because the forms are already burdened with Tab Controls and many other controls on each Tab.  In the past, I had bad experiences in previous Access versions with embedded Excel. Hopefully this version will cooperate and play nice for me.  I will get a chance later on to experiment and then report back.

Author Comment

by:DAY 3
ID: 41792213
I started the process of embedding an Excel chart in one of my forms to replace the simple access graph.  Other than a recalc flicker, I think it would work.  But I have a dozen of these graphs, 5 of which are within tabs on one form.  I resent having to further burden these forms with Excel when I know Access works perfectly already.... except for on this machine.
I spent 3 hours on the phone talking with 4 different tech experts at Microsoft; two of which remoted into my machine and were amazed with my problem.  They accused me of having a complex application, so I downloaded one of their generic Northwind databases and put a simple graph on a form to show them the exact same problem.... which only occurs on my machine.
So after doing diagnostics on my machine and current updates, they confirmed that they don't see anything wrong.  They were supposed to get additional tech people to contact me today, but I haven't heard back yet.
I will continue to update my progress.

Accepted Solution

DAY 3 earned 0 total points
ID: 41832735
Thank you Pat for offering assistance on this.
After numerous visits with Microsoft Tech support who remotely logged into my computer to experience my problem, I also visited an expertly staffed Microsoft store to demonstrate the issue, but mostly to demonstrate on other Surface Pro 4’s.  When every machine we looked at had the same problem under similar circumstances, it was easy to conclude that the Surface Pro 4 has a bug.
I also found out that setting my docking station to only display on the remote monitor, I can design with proper graph scaling on that screen.  Until MS comes out with a firmware patch for the Surface, I can live with this compromise.  There are very few circumstances where resolution is misrepresented.
LVL 36

Expert Comment

ID: 41832752
I'm sorry it wasn't something they could fix for you.  Perhaps, they will figure out the problem and someday it will be resolved.  At least you have something you can work with in the mean time.

Author Closing Comment

by:DAY 3
ID: 41838059
I don't want to mislead anyone doing a search that there was a solution to this problem.  There was no solution to the problem, but I discovered an acceptable way of working around it.
The solution that Pat Hartman suggested is also a work-around that I have used for other reasons in other projects, but it wouldn't be acceptable here.

Expert Comment

by:Steve Sayko
ID: 41889820
Regarding the resizing of Access Charts that began in late 2016, I am having the same problem with graphs resizing.   Resizing occurs on multiple computers and in the PDF print out.  These are reports that have been functioning perfectly for years on many different computers and printers.  I rely on generating 100s of pages of graphs directly from Access.  The last post on this topic was October 11, 2016.  Has there been any progress since then?

Expert Comment

by:Steve Sayko
ID: 41891536
I have checked the 3 computers in my office with Office 365, two have the chart resizing problem, one is OK.  
  PROBLEM - HP Laptop Windows 10 Pro 64-bit / Office Update 16.0.6965.2092
  PROBLEM - DELL Laptop Windows 10 Pro 64-bit / Office Update 16.0.6965.2105
  WORKING - DELL Desktop Windows 10 Pro 32-bit / Office Update 16.0.6965.2105
It's a small sample but the 32-bit Windows works, the 64-bit Windows fail.

Author Comment

by:DAY 3
ID: 41891751
Hi Steve, my Surface and Office 10 has updated twice since this problem was posted, but the sizing issue still persists.

Surface Pro 4 i7 with 64-bit Windows 10

I have used the machine substantially more in the past few months, and my resizing issue still seems to be limited to some video’s (usually pre-video promotions) and with all graphs within MS Access.  I do a good bit of PDF generation within Access, and I haven’t seen any PDF sizing issues.

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Incoming email read aloud on Android 1 28
Office 365 Resource Calendars aka "Rooms" 4 38
Lync 2010 Certificate 3 11
run FileCopy code from a string 5 11
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In a previous video Micro Tutorial here at Experts Exchange (, I explained how to get a free, one-month trial of Office …
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question