CFChart Issue - Pie Chart

Posted by Joshua in on February 26, 2008

I have a customer who wants some charts in a PDF report they already get from an application. One of the charts is a Pie Chart and displays the dollar breakdown.  I ran into an issue with the value labels overlapping each other so I did some research and found this in the update docs. 

I made the changes to the default_pie.xml file and the other standard pie styles as indicated in the update documentation.  However I am still running into this problem with the label overlap.  I have also tried sorting these values in different ways to try and make the overlap disappear, but I have been unsuccessful. 

I have attached a sample pie chart, if anyone has a solution or an idea how to fix this let me know please (note the data overlays).



<cfquery dbtype="query" name="divChartQuery">
   select providerInvestTotalByDiv, div_name, div_shortname
   from qNeeds
   where provider_name = '#qNeeds.provider_name#'
   order by providerInvestTotalByDiv, div_shortname
</cfquery>

<cfchart format="png" xAxisTitle="Divisions"
      yAxisTitle="Total Allocation" show3d="false"
      chartheight="375" chartwidth="425" style="yellow"
      labelformat="currency">
   <cfchartseries type="pie"                   
      query="divChartQuery"         
      valueColumn="providerInvestTotalByDiv"
      itemColumn="div_shortname"/>
</cfchart>

Most of the 640-802 and 70-649 pros will know the answer to this issue. You don’t need to have a 640-822 or a 640-863 to figure this out. Basic certifications like 70-293 can help you in achieving that.

  1. Terrence Ryan

    #1 by Terrence Ryan - February 26, 2008 at 8:45 PM

    I'm having this same problem. I'm subscribing to find out if anyone else has this issue
    Reply
  2. Dan G. Switzer, II

    #2 by Dan G. Switzer, II - February 27, 2008 at 6:24 AM

    @Joshua:

    Since the main problem is with large numeric values, can you just display the value in millions? Use 1.98m instead of 1,975,000.00.
    Reply
  3. Joshua

    #3 by Joshua - February 27, 2008 at 6:52 AM

    Dan - I might try that for the time being. Do you have a code sample on how to achieve this? I was using the labelformat=currency to get the dollars.

    All,
    I am sending some sample data to Adobe to see if they can replicate the issue.
    Reply
  4. Josh

    #4 by Josh - February 27, 2008 at 12:57 PM

    Dan, I tried the reformat to 1.98M, it still over laps :( I looked into seeing if the lines could be made longer via the xml style and it doesnt look like that is possible.
    Reply
  5. Ahamad

    #5 by Ahamad - March 30, 2008 at 11:37 PM

    Hi,
    I have been able to reproduce this issue. Thanks for bringing up this. We are working on this and will let you know once the issue is resolved.

    Thanks,
    ahamad
    Adobe CF Team
    Reply
  6. Laurie

    #6 by Laurie - May 17, 2008 at 12:02 PM

    Josh,

    I had the same issue. I didn't find a fix, but I found a workaround. First, instead of changing the default_pie.xml file, I made a copy of the file and placed it in the root of the directory my chart webpages are in on my website. I renamed the file and then refered to it in the <cfchart> tag on the individual webpages I want to use it with using style="mystyle.xml".

    <<cfchart chartwidth="550" chartheight="250" pieslicestyle="sliced" labelformat="number" tipstyle="mousedown" font="Times" fontsize="12" show3d="yes" yoffset="-1" backgroundcolor="##FFFFFF" style="mystyle.xml">
    <cfchartseries query="pq1" itemcolumn="sdesc" valuecolumn="Q1total" type="pie" datalabelstyle="pattern" colorlist="#valuelist(pq1.scolor)#"/>
    </cfchart>

    In the mystyle.xml document I added a new attribute "angle". Playing with the angle allowed me to rotate my 3d pie charts to a position in which the labels no longer overlap. It's not perfect, but it works.

    <<pieChart depth="Double" style="Solid" angle="150" is3D="false">>
    Reply
  7. house dj

    #7 by house dj - September 10, 2008 at 5:49 AM

    Hi, i find it cool, that ADOBE will fix this problem.
    Reply
  8. Manuela

    #8 by Manuela - August 28, 2009 at 2:21 PM

    Badly need your help. Hello. My nick's Manuela.wanna see me on my page? Tell me, have I exactly. Help me! Help to find sites on the: Handmade soap samples. I found only this - <a href="http://www.geo600.de/Members/Soap/handmade-moisturising-soap">handmade moisturising soap</a>. Side Effects: Handmade soap wholesale usa only: the builder of jamawar has based exclusive to the own soaps of product skills and thread gangster. Ross boatman became down a drying conquest in the creation, as he fretted about apply to be skimmed striking his heptarchy in hard men. Best regards :cool:, Manuela from Yemen.
    Reply
  9. Lindy

    #9 by Lindy - August 30, 2009 at 10:39 PM

    Taras know, i will fuck my father, thank you. Help me! There is an urgent need for sites: Opalescence carbamide peroxide I found only this - <a href="http://www.adk-bw.de/Members/Opalescence/does-opalescence-work">does opalescence work</a>. Introducing density systems he suggested his all constructed optic viable system model to scatter, opalescence 15 instructions. opalescence pf 20 instructions. Thanks for the help :eek:, Lindy from Cape.
    Reply
(will not be published)