Solved

MS Access right-side of chart gets cut off

Posted on 2016-09-03
4
65 Views
Last Modified: 2016-10-03
Dear Experts,

Okay been trying to figure this one out for about a day now and nothing I find online is helping.

When I edit my chart the data all shows up:
screenshotHowever, when I preview the form the data gets cut off!
screenshot2The chart is currently set to 'clip' in format but I've tried 'stretch' and 'zoom' as well with no luck. Is there a way I can set the margins? Or perhaps fix the scale on the z axis to display values from 7 to 24? As there will not be values beyond these values?

Looking for some guidance here..

Thanks!
0
Comment
Question by:shogun5
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41783701
Assuming you mean Preview to be what it will look like when you print: the size that shows is determined by the paper size -- try setting to Landscape and making the margins narrower.  You can also make the Width narrower for the chart object.

> "Is there a way I can set the margins?"
On the Print Preview ribbon, choose the Margins icon. If you are in Design View, use the PAGE SETUP ribbon tab of the REPORT DESIGN TOOLS.

> "fix the scale on the z axis to display values from 7 to 24"
in design view, double-click on the chart object to edit it then right-click on the axis you want to change and choose "Format Axis..." from the shortcut menu -- then choose Scale tab in the Format Axis dialog box
0
 

Author Closing Comment

by:shogun5
ID: 41783714
Crystal,

Awesome! That's what I needed to know. Your answer provided enough information to help me fix my problem. For anyone else reviewing this post the resolution was first adjusting the scale then I in preview mode on the form ( not working on a report) I right clicked on the chart >> edit chart  then I clicked on the border of the chart and fiddled with the edges of the chart, moving the right border in a bit then out and it seemed to 'push' the right side in enough so now all my data is showing. I put this under "things that are not written in any book".
Thanks again for chiming in and assisting!
0
 
LVL 19
ID: 41783739
you're welcome ~ happy to help

be sure to drag the right boundary of the form in too (in design view, hover over it and click/drag when mouse becomes vertical line with double-headed horizontal arrow) so an extra blank page is not created

btw, you CAN put a form on a report as a 'subreport' even though it is a form ...
0
 

Expert Comment

by:Jim Martin
ID: 41827175
This effect happened to me on charts I produce annually.  Since last year we upgraded to Office 365 and got new computers.  I tried everything mentioned on this and other posts.  Turns out the problems was solved when I went to control panel/display and changed from 125% to 100%. view size.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

810 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