+ Reply to Thread
Results 1 to 3 of 3

Overlaping bar chart percentage data label location help

  1. #1
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Overlaping bar chart percentage data label location help

    I have an overlapping bar chart showing TY vs LY results. On my chart, I'm including TY and % data labels. I would like to get my "% data label" to automatically appear somewhere it can be read. Right now, it is stacked on top of the Customer name or over the top of my "TY data label".

    I'm not particular on where the "TY data label" and the "% data label" are on the chart as long as it can be read.

    Thanks for your help.
    Attached Files Attached Files

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

    Re: Overlaping bar chart percentage data label location help

    as the 2015 data series is on the secondary axis you could use the secondary vertical axis to display the percentages.
    Add the secondary axis and then via the select data dialog change the category label range for that series.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Re: Overlaping bar chart percentage data label location help

    That is perfect. Thank you!!

+ 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. URGENT pls help me with this overlaping bar chart
    By spartacus13 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-31-2013, 03:21 PM
  2. Replies: 1
    Last Post: 01-27-2012, 09:17 AM
  3. two worksheets overlaping data
    By oddcarout in forum Excel General
    Replies: 3
    Last Post: 05-16-2008, 06:06 PM
  4. Remove Chart Label with Percentage 0.
    By Owais in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2006, 04:00 AM
  5. Percentage in data label
    By Darryl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-09-2005, 11: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