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'.
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:
However, when I preview the form the data gets cut off!
The 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!
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:
However, when I preview the form the data gets cut off!
The 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!
Asked:
2
1 Solution
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!
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!
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 ...
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 ...
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 Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
> "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