Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Access right-side of chart gets cut off
Posted on 2016-09-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:
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!
[X]
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
2
4 Comments
Active 1 day ago
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
> "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
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!
Active 1 day ago
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 ...
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
- The Email Laundry
- Email Servers
- Cybersecurity
- Email Protocols
- Network Security
- Security, *Phishing
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 19 hours left to enroll
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.