+ Reply to Thread
Results 1 to 12 of 12

I need to place 3 labels on each bar of a chart

  1. #1
    Registered User
    Join Date
    06-30-2018
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    9

    I need to place 3 labels on each bar of a chart

    Hello
    I need to place 3 labels on each bar of a chart:Untitled.jpg
    - one is data label above each column of the chart, which is easy;
    - other 2 are texts from cells linked to the data:
    -- one on the upper end of the bar;
    -- another one on the lower end of the bar, - like in the picture.

    Please do not suggest text boxes. I tried and not too happy.
    Any help will be gratefully appreciated.
    Thank you.
    Galina

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,503

    Re: I need to place 3 labels on each bar of a chart

    The attached shows one way of doing this. It involves adding additional series to the chart, adding data labels to them driven by the data in columns C & D, setting the three sets of data labels to one outside, one inside end and one inside base.
    Then you can overlap the bars so you only see one.

    Good news is it's a quick and simple fix to your issue. Bad news is in Excel 2010 (I think!) you need to set each data label separately, so if you have lots and lots of points on the chart it will be a headache. Although you could probably write some VBA to do that for you...
    In Later versions of Excel you can change all data labels in one go.

    BSB
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-30-2018
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    9

    Re: I need to place 3 labels on each bar of a chart

    Hi,
    thank you very much!
    I do appreciate your help!
    There was a request to click * in the end of your post to show appreciation, how?
    Best Wishes, Galina

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: I need to place 3 labels on each bar of a chart

    try this

    addrep.jpg
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  5. #5
    Registered User
    Join Date
    06-30-2018
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    9

    Re: I need to place 3 labels on each bar of a chart

    Dear Sandy,
    This video of creating timeline project was really very interesting!
    Although I used the method recommended by BadlySpelledByou, it is inspiring to know how to use unusual capabilities of mighty Excel.
    Thank you very much.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: I need to place 3 labels on each bar of a chart

    Quote Originally Posted by galkas View Post
    There was a request to click * in the end of your post to show appreciation, how?
    This is a question

    Quote Originally Posted by sandy666 View Post
    This is an answer how to do it

    No more No less

  7. #7
    Registered User
    Join Date
    06-30-2018
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    9

    Re: I need to place 3 labels on each bar of a chart

    Thank you, but the attachment doesn't open?
    I just see a black screen with "add reputation, report post".
    Best Wishes

  8. #8
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: I need to place 3 labels on each bar of a chart

    If you want to add Reputation to BSB click Add Reputation in BSB profile (Left side). This is not so hard

  9. #9
    Registered User
    Join Date
    06-30-2018
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    9

    Re: I need to place 3 labels on each bar of a chart

    Indeed it is not.
    And I tried, nothing happened.

  10. #10
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: I need to place 3 labels on each bar of a chart

    I'll try again

    addrep01.gif

    Have a nice day

  11. #11
    Registered User
    Join Date
    06-30-2018
    Location
    Bristol
    MS-Off Ver
    2010
    Posts
    9

    Re: I need to place 3 labels on each bar of a chart

    Dear Sundy,
    I do understand.
    When I try your attachment, I get a black screen with "Add reputation, report post" and nothing can be clicked.
    I suppose problem is in your attachment? Would you like to send it via e-mail?
    Tha.
    Galina

  12. #12
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: I need to place 3 labels on each bar of a chart

    There is picture only. To show you what * means. Nothing more and nothing to click in the post

    I give up

    [unsubscribed]

+ 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. Adding Horizontal Axis Labels to Chart without Selecting the chart
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2017, 11:32 AM
  2. [SOLVED] Adding Horizontal Axis Labels to Chart without Selecting the chart
    By Jonathan78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2017, 04:02 PM
  3. [SOLVED] Place Row Labels in Single Row?
    By mcclanat in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-11-2015, 03:09 PM
  4. how to place the dynamic labels in a table format on a userform
    By yoursamrit2000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2015, 02:20 AM
  5. Replies: 1
    Last Post: 10-23-2014, 01:59 PM
  6. Change chart/pivot table numeric labels to associated text labels
    By petschek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-07-2014, 05:32 PM
  7. Using Labels in Place of Cell Ref in Formulas
    By sudburydave in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 10-21-2007, 05:40 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