+ Reply to Thread
Results 1 to 2 of 2

labeling stacked column graph

  1. #1
    Registered User
    Join Date
    09-17-2010
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    23

    labeling stacked column graph

    I'm creating a stacked column graph to create a debt maturity schedule and each column consists of two variables, fixed rate and variable debt, and I'd like the data labels to show the sum of the fixed and variable debts, instead of having two data labels per column showing the values of the variable and fixed rate debt seperately.
    Last edited by dadevil; 09-30-2010 at 12:35 PM.

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

    Re: labeling stacked column graph

    add a line series which is the sum of each of the 2 data values. apply data labels and align them above.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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