Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access 2010 Pie charts not rendering in PDF

Posted on 2015-02-01
9
Medium Priority
?
153 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
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

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.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

581 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