+ Reply to Thread
Results 1 to 5 of 5

changing labels

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    Oz
    MS-Off Ver
    Excel 2013
    Posts
    63

    changing labels

    Hi,

    This request is for Excel 2013 & 2016

    1. Is it possible to change the data labels from a number to the Percentages. I will need the numbers (0 to 8) along the x-axis as it currently is displayed but i want the Percentages displayed after the bars instead of the numbers
    2. Is it possible to have the start date (cell:C16) underneath the 0 and end date (cell:C17) underneath the 8 on the x-axis.

    Thank you

    Andy
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: changing labels

    I would add a couple helper columns for your chart:
    In O8, enter:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and copy down - format as Date

    In P8, enter:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and copy down - format as %

    Now use O8:O14 as the source range for your chart series. Add the Data Labels, then in Label Options > Label Contains, select "Value From Cells", and select range P8:P14.

    Does this display as you wanted? (see attachment for worked example)
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    04-08-2014
    Location
    Oz
    MS-Off Ver
    Excel 2013
    Posts
    63

    Re: changing labels

    Thank you

    I attached a file showing how i hope to get it to look. I manually added some features just to demonstrate how i would like it to look

    Thanks again for your help
    Attached Files Attached Files

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: changing labels

    You could add a second data series (with zero values) and plot on a secondary axis, then format this secondary axis with a minimum value of your start date, a maximum value of your end date, and a major unit value of the interval between them. Format the axis label position as Low.

    Format the primary axis with minimu value 0, maximum value 8, and major unit 1.

    End result looks pretty close to what you wanted
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-08-2014
    Location
    Oz
    MS-Off Ver
    Excel 2013
    Posts
    63

    Re: changing labels

    Yes that what i was after....thank you

    Just a question
    1. How did you have the date inserted in the Chart?
    2. How do i reverse the names in the chart so they are sorted A to Z

    Thanks

+ 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. Want to store a Labels value at the same time as changing to 0
    By KJC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2013, 09:48 PM
  2. Changing chart axis labels
    By jshaw82 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 01-21-2013, 05:08 AM
  3. Changing labels caption gives error
    By mjcordeiro in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-18-2012, 02:14 PM
  4. Excel 2007 : x-axis labels not changing with scroll
    By almagg in forum Excel General
    Replies: 2
    Last Post: 02-07-2011, 03:38 AM
  5. Changing horizontal axis labels problem
    By Jcarroll in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-15-2009, 04:36 AM
  6. XY Scatter: Changing Horizontal Axis Labels
    By smurray444 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-16-2007, 11:52 AM
  7. Programatically Changing Hover Labels
    By David in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2005, 08:05 AM
  8. [SOLVED] Changing the inner border of bar labels?
    By Xaver Hinterhuber in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-03-2005, 08:05 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