Help Needed with Chart

[Legacy 388346]

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]

 

[Jon Peltier]

Your images do not appear.

 

[Legacy 388346]

[/IMG]

[/IMG]

 

[Jon Peltier]

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]

Sorry, I meant to link more directly to Broken Y Axis in an Excel Chart.

 

[Legacy 388346]

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.

 

[Jon Peltier]

Did you look at the web page since asking for the file? I have changed that section so it shows all of the steps.