• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

MS Access right-side of chart gets cut off

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
shogun5
Asked:
shogun5
  • 2
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
shogun5Author Commented:
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
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
Jim MartinCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now