+ Reply to Thread
Results 1 to 3 of 3

Adding 2nd Data Label Series to Bar of Pie Chart

  1. #1
    Registered User
    Join Date
    11-07-2018
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    7

    Adding 2nd Data Label Series to Bar of Pie Chart

    Hello Users! I have done some preliminary research on the forum, and was able to get this far, but I need a little help pulling this chart across the finish line.

    The goal is to show how much marketing budget is spent on "evergreen spend" vs "new spend" and then breakout the % of "new spend" by tactic. I think the bar chart would look best with the tactic name in the bar, and then the percentage of "new spend" to the outside right of each respective tactic + leader lines.

    I would like to use the category label + value label for the pie chart, and then use category label + percentage label for the bar of pie chart. I was able to duplicate the data series, though I'm not quite sure how to proceed form here.

    If you could help me affect these changes, or even recommend a better view/format, I'd be very grateful!!

    Thanks so much!
    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,434

    Re: Adding 2nd Data Label Series to Bar of Pie Chart

    If you use 2 sets of the same data in the chart you can create 2 pie/bar charts, with one appearing on the secondary axis.

    Make sure the settings for bar/pie formatting are the same.
    Add data labels to each series. Format one to show names the other values.

    Within the pie you may want to delete the name data labels.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-07-2018
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Adding 2nd Data Label Series to Bar of Pie Chart

    Thank you so much Andy!! This is very helpful!

+ 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. VBA to Identify the Data Series Label Location on the Chart Area
    By cartica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2017, 08:52 PM
  2. Replies: 4
    Last Post: 01-26-2016, 05:08 AM
  3. add Data label using vba in a chart series with named range
    By tomjohns24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-27-2015, 05:28 PM
  4. How to Custom Label a Single Data Point When Adding New Series
    By DixiePiper in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2015, 05:25 PM
  5. Replies: 6
    Last Post: 11-26-2012, 05:17 AM
  6. Pie Chart - Adding 2nd data label series?
    By Bjornago in forum Excel General
    Replies: 6
    Last Post: 01-19-2010, 08:39 PM
  7. Adding a label to a data point in a chart??
    By Fish in forum Excel General
    Replies: 1
    Last Post: 03-13-2006, 07:25 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