Access 2010 Pie charts not rendering in PDF

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
Who is Participating?
DarrellDoesDataConnect With a Mentor Author Commented:
The problem was apparently caused by the custom colors. It was solved by selecting Automatic in the Format Data Series dialog...

Corrected image...
Jeffrey CoachmanMIS LiasonCommented:
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?

DarrellDoesDataAuthor Commented:
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.
Never miss a deadline with

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Jeffrey CoachmanMIS LiasonCommented:
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.

DarrellDoesDataAuthor Commented:
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?
Jeffrey CoachmanMIS LiasonCommented:
Then you have to make the chart bigger.

If not, then post a small sample database that exhibits this symptom, and I will investigate.
DarrellDoesDataAuthor Commented:
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>
Jeffrey CoachmanMIS LiasonCommented:
Probably, ...
But again, I will need a sample database that exhibits this symptom,
DarrellDoesDataAuthor Commented:
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.
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.

All Courses

From novice to tech pro — start learning today.