+ Reply to Thread
Results 1 to 2 of 2

Steering Wheel Chart Data Label Size. How do I change the size?

  1. #1
    Registered User
    Join Date
    12-14-2018
    Location
    Bury St Edmunds, England
    MS-Off Ver
    2016
    Posts
    2

    Steering Wheel Chart Data Label Size. How do I change the size?

    Hi,

    I've put together a donut chart to represent data in a traffic light system. I have made a function to take my data and change the colours of the segments.

    My problem is that the data labels bound boxes are too small. How can I change these? If text boxes are the only option is there a neater way to rotate these over then dragging the rotate handle?
    Attached Files Attached Files
    Last edited by PhilHP; 12-17-2018 at 04:25 AM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Steering Wheel Chart Data Label Size. How do I change the size?

    minor improvements attached....
    you can increase size by increasing Font size and turning off Word Wrap
    you will need to move individual data labels because they are no longer readable

    however at the end of the day you really only have so much real estate to work with
    especially with long labels like
    Scanned Dispatch
    Fulfilment Inc. SDF
    Fulfilment
    Negative Balances

    you might want to consider acronym them like FTE
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Steering Wheel KPI
    By jamesa2487 in forum Excel General
    Replies: 4
    Last Post: 12-14-2018, 03:10 PM
  2. [SOLVED] Can I change Font size without changing cell size? Or confine row height change to one col
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2018, 11:18 AM
  3. Some label controls change apparent font size when moved up/down
    By GJL65 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2016, 01:12 PM
  4. Changing Page Size - Only gives label size options
    By etouch in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-31-2016, 02:40 PM
  5. Change font size keeping the cell size fixed
    By mayurpatil in forum Excel General
    Replies: 1
    Last Post: 07-09-2015, 01:52 PM
  6. Replies: 0
    Last Post: 07-09-2013, 02:21 PM
  7. how do I change the size of the y-axis label?
    By Alex in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-15-2013, 09:43 AM

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