Solved

Access 2010 Pie charts not rendering in PDF

Posted on 2015-02-01
9
135 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

821 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