Help Needed with Chart

L

Legacy 388346

Guest
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]
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
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.
 
L

Legacy 388346

Guest
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

MrExcel MVP
Joined
May 14, 2003
Messages
4,851
Office Version
365
Platform
Windows, MacOS
Did you look at the web page since asking for the file? I have changed that section so it shows all of the steps.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,800
Messages
5,446,554
Members
405,406
Latest member
tuxy

This Week's Hot Topics

Top