Results 1 to 7 of 7

Help Needed with Chart

This is a discussion on Help Needed with Chart within the Excel Questions forums, part of the Question Forums category; Hello, I am hoping someone can help me with this. I am trying to create a chart with a series ...

  1. #1
    New Member
    Join Date
    Oct 2016
    Posts
    12

    Default Help Needed with Chart

    Hello, I am hoping someone can help me with this.
    I am trying to create a chart with a series of data for two years. I need to split the chart so that it looks like the second image. That being the lower values display in the bottom half of the chart and the higher values on top. I have tried for days to do this and I can just not able to get this to work. Your help is greatly appreciated. [IMG][/IMG]



    [IMG][/IMG]

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,365

    Default Re: Help Needed with Chart

    Your images do not appear.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  3. #3
    New Member
    Join Date
    Oct 2016
    Posts
    12

    Default Re: Help Needed with Chart

    [IMG][/IMG]



    [IMG][/IMG]

  4. #4
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,365

    Default Re: Help Needed with Chart

    Coincidentally, correspondence in another forum encouraged me to rewrite the example on Broken Y Axis in an Excel Chart with a more detailed procedure for constructing the chart.

    I was going to repeat that here with your data, but you posted a picture of the data, not the data.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  5. #5
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,365

    Default Re: Help Needed with Chart

    Sorry, I meant to link more directly to Broken Y Axis in an Excel Chart.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  6. #6
    New Member
    Join Date
    Oct 2016
    Posts
    12

    Default Re: Help Needed with Chart

    I have tried following those basis but could not create the chart. I replied on that board asking if you had the xls file so I could see what steps you did? I just can't get this to work. Could you demonstrate step by step how to do this? I got all the way to the 2nd series on the secondary axis but then it just went over my head and no matter what I could not get it to separate no matter how much i tried to change the values.

  7. #7
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,365

    Default Re: Help Needed with Chart

    Did you look at the web page since asking for the file? I have changed that section so it shows all of the steps.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com