Labeling on independently stacked line chart

Discussion in 'Excel Charting' started by Deb P, May 23, 2013.

  1. Deb P

    Deb P Guest

    Hi,

    I need to display percentage results from 8 stores in one chart, wit
    each store having a line (trended over time). They are positioned on
    above another, ultimately, in PowerPoint. The lines are not cumulativ
    - they are independent.

    From another site, I figured out how to do this by giving the firs
    store ratings from 0 to 100%, the second store 100 to 200%, etc. Thi
    gets the position I want for the charts. I do not need to display an
    values on the y-axis.

    However, I DO need to display the data labels. I'm looking for a
    automated way to change 795%, for example, to 95%. I can do thi
    manually in the data label but once it's changed manually, an
    underlying change to the data won't update.

    Any recommendations


    --
    Deb P
     
    Deb P, May 23, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Pablo

    stacked column and non-stacked single line

    Pablo, Feb 24, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    273
    auee99
    Oct 29, 2004
  2. NYBoy

    Line chart, value labeling

    NYBoy, Apr 15, 2004, in forum: Excel Charting
    Replies:
    19
    Views:
    545
    Andy Pope
    Apr 19, 2004
  3. Jon Peltier
    Replies:
    2
    Views:
    260
    Jon Peltier
    Jan 22, 2005
  4. Jacqueline
    Replies:
    1
    Views:
    229
    Debra Dalgleish
    Feb 17, 2005
  5. y
    Replies:
    3
    Views:
    214
    Jon Peltier
    Mar 17, 2008
  6. Sin
    Replies:
    8
    Views:
    238
  7. Robyda
    Replies:
    4
    Views:
    284
    Jon Peltier
    Aug 24, 2008
  8. John Brenner

    Labeling points on a line chart

    John Brenner, Dec 11, 2008, in forum: Excel Charting
    Replies:
    1
    Views:
    128
    Jon Peltier
    Dec 12, 2008
Loading...