Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2010 Pie charts not rendering in PDF

Posted on 2015-02-01
9
Medium Priority
?
151 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
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

916 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