Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2010 Pie charts not rendering in PDF

Posted on 2015-02-01
9
Medium Priority
?
149 Views
Last Modified: 2015-02-23
I have pie charts embedded in an Access 2010 report. The charts render just fine when printing directly from Access, but when I output to PDF, the pies turn into blocks.
Access output:
Pie charts in Access
PDF output:
Pie charts in PDF
Piechart properties:
Pie chart properties
Output code:
    DoCmd.SelectObject acReport, rptName
    DoCmd.OutputTo acOutputReport, rptName, acFormatPDF, ReportFile, True
0
Comment
Question by:DarrellDoesData
[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
  • 5
  • 4
9 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40583144
This worked fine for me in Access 2010.

A few suggestions.
1. Open the report in design view and make the cheat object a little bigger.
2. Are you using a custom color scheme? If so then try recreating the chart with the standard color pallet
3. Eliminate all the other labels, and just display the value.
4. Make sure you have all your Windows and Office updates installed.
5. compact/repair the DB
6. Recreate the chart.

Other questions:
a. What app are you using to view the PDF?, ...I am using the standard Adobe Acrobat free viewer.
b. Is this issue for all charts?, All Users, All machines?

JeffCoachman
0
 

Author Comment

by:DarrellDoesData
ID: 40584372
Thanks, Jeff. I finally figured it out after I posted this message, through lots of trial & error. The cause of the problem turned out to be what you suggested in #2. It had a custom color scheme, and when I changed it to Automatic it rendered fine in the pdf.
I do have another question -- is there a way to prevent labels from overlapping? These are 4-slice pie charts and frequently 2 of the slices are very narrow and their labels merge. The labels contain the numerical value and the percent.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40585373
is there a way to prevent labels from overlapping?
Part of the reason for the overlap is that you are displaying 3 values for each series.  This increases the space each series label takes up.
A few things to fix this:
1. Decrease the font size of the labels
2. Add "Leaders" to each slice/label, then pull them apart apart.:
Open the report in design view
Double click the chart
Double Click on a pie wedge
Select: Show Leader Lines
Click OK
Click a Label *Once* and release it
Now click and drag that label wherever you like.

In this example, you really did not have to add the leaders, ...but adding them makes it easier to discern what label belongs to what slice.
;-)

JeffCoachman
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:DarrellDoesData
ID: 40585385
Jeff,
I already did what you suggested. I moved the slice name into the legend so now there are only 2 values. I have leader lines turned on, but they don't always appear. I tried moving the labels around but that doesn't resolve the overlap in every case -- it depends on where the skinny slice(s) ends up relative to the slice next to it.
OverlappingLabels.pngAm I missing something else?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40585407
Then you have to make the chart bigger.

If not, then post a small sample database that exhibits this symptom, and I will investigate.
0
 

Author Comment

by:DarrellDoesData
ID: 40585460
OK, I get it. I haven't got much extra room on this report because the charts are displayed ion the bottom 1/3, but I'll fiddle around with it.

Here's another question:
In the pie chart displayed above, the zero-value is actually a negative value. I want to treat the negative value as a zero, but I'd like to display it's amount as ($626,114) in the slice label. Is there a way to do that>
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40585535
Probably, ...
But again, I will need a sample database that exhibits this symptom,
0
 

Accepted Solution

by:
DarrellDoesData earned 0 total points
ID: 40616995
The problem was apparently caused by the custom colors. It was solved by selecting Automatic in the Format Data Series dialog...
 
PieChartRenderingFix.png

Corrected image...
 PieChartRenderingFix2.png
0
 

Author Closing Comment

by:DarrellDoesData
ID: 40625315
I'm not sure why the custom colors wouldn't render, but I guess nobody else had ever encountered that before. I found the solution through trial & error.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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