Labeling on independently stacked line chart

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

  1. Deb P

    Deb P Guest


    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, May 23, 2013
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.