+ Reply to Thread
Results 1 to 5 of 5

Line Chart Y-Axis is subdivided into discrete ranges same x-axis

  1. #1
    Registered User
    Join Date
    07-12-2010
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    5

    Line Chart Y-Axis is subdivided into discrete ranges same x-axis

    Hi,

    I have searched the internet high and low to figure this out but still haven't found an answer. I need my y-axis of a line chart to subdivided into sections. So for the first range of 5 - 1 there is a line graph over an x axis going left to right. Then in the next range of values 5 - 1 there is a different line graph over the same x axis.

    5
    4
    3
    2
    1
    ---------------
    5
    4
    3
    2
    1
    ---------------
    5
    4
    3
    2
    1

  2. #2
    Registered User
    Join Date
    07-12-2010
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Line Chart Y-Axis is subdivided into discrete ranges same x-axis

    Check out my attachment for help understanding.
    Attached Images Attached Images

  3. #3
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Line Chart Y-Axis is subdivided into discrete ranges same x-axis

    The image you posted is from http://peltiertech.com/Excel/Charts/StackedCharts.html

    Did you follow the tutorial in there? It really has all the steps you need.

    cheers,

  4. #4
    Registered User
    Join Date
    07-12-2010
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Line Chart Y-Axis is subdivided into discrete ranges same x-axis

    Yah I did attempt to follow it but my scale of numbers is different. I'm still trying at it.

  5. #5
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Line Chart Y-Axis is subdivided into discrete ranges same x-axis

    post a file with how far you got to illustrate where you got stuck.

+ 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