+ Reply to Thread
Results 1 to 7 of 7

Rotate data labels in Donut chart in 18Oo

  1. #1
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Rotate data labels in Donut chart in 18Oo

    Sir

    please give a solution to rotate data value in donut chart to rotate in 180 degree

    i can rotate upto 90 degree ,but i want to rotate the data value upto 180 degree

    please give a solution to solve this

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Rotate data labels in Donut chart in 18Oo

    Don't think you can manipulate the data label so the text is inverted.

    You can use shapes to replace data labels and then rotate those through 180 degrees
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Rotate data labels in Donut chart in 18Oo

    thanks for your reply

    but when i use shape or word art inside of data label,,,,, when i am priting shape or wordart not showing in the exact location,... its move to someother location

    how can i solve this issue to keep word art to keep in same location where i placed when i am printing... i try to print in pdf printer

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Rotate data labels in Donut chart in 18Oo

    are the shapes embeded within the chart?

    perhaps post an example file so we can see the problem

  5. #5
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Rotate data labels in Donut chart in 18Oo

    here its sample file attached with this


    thanks for your reply
    Attached Files Attached Files

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Rotate data labels in Donut chart in 18Oo

    The example file now has a macro to add textboxes.

    The printed / pdf output still screws up. So you might need to copy as picture and use that in output.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-17-2014
    Location
    Dubai
    MS-Off Ver
    Excel 2013
    Posts
    86

    Re: Rotate data labels in Donut chart in 18Oo

    thanks for ur reply

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Recreate this donut chart?
    By IronCladRooster in forum Excel General
    Replies: 2
    Last Post: 12-16-2014, 03:44 PM
  2. [SOLVED] Rotate data labels to be vertical
    By oneillp1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2014, 07:50 AM
  3. Rotate x category labels in a pivot chart.
    By guntherda in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-01-2013, 06:33 AM
  4. how to make a Donut Chart
    By mushman1 in forum Excel General
    Replies: 4
    Last Post: 06-22-2010, 04:54 PM
  5. Conditional Formating-a Donut/Speedometer chart.
    By Tempus in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-12-2006, 03:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1