Show two value ranges on one axis
 

How do you show two value ranges of the same data on one axis? (the axis
range is separated by a zigzag/heartbeat style line). e.g. instead of showing
0-50, the axis could show 10-25 and 40-45.

Any help appreciated!

Take a look at Jon Peltier's Broken Y axis example.

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

"NOKIA" wrote in message
...
How do you show two value ranges of the same data on one axis? (the axis
range is separated by a zigzag/heartbeat style line). e.g. instead of
showing
0-50, the axis could show 10-25 and 40-45.

Any help appreciated!

Thanks for that - very thorough! Is there not a quicker
solution?

-----Original Message-----
Take a look at Jon Peltier's Broken Y axis example.

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

"NOKIA" wrote in message
...
How do you show two value ranges of the same data on
one axis? (the axis
range is separated by a zigzag/heartbeat style line).
e.g. instead of
showing
0-50, the axis could show 10-25 and 40-45.

Any help appreciated!


.

Having worked through the example and downloaded the
relevant add-in, how do you 'add the labels in H2:H13 to
the Markers series along the Y axis' using the Chart
Labeler?

Thanks again!

-----Original Message-----
Thanks for that - very thorough! Is there not a quicker
solution?

-----Original Message-----
Take a look at Jon Peltier's Broken Y axis example.

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

"NOKIA" wrote in
message
news:2564B7F7-0693-4A7E-A5C8-
...
How do you show two value ranges of the same data on
one axis? (the axis
range is separated by a zigzag/heartbeat style line).
e.g. instead of
showing
0-50, the axis could show 10-25 and 40-45.

Any help appreciated!


.

.

Select TOOLS, XY Chart Labeler, Add Chart Labels.

If you don't have the XY Chart Labeler on your list of tools, you'll have to
select it using the ADD-INS menu on the TOOLS menu.

wrote in message
...
Having worked through the example and downloaded the
relevant add-in, how do you 'add the labels in H2:H13 to
the Markers series along the Y axis' using the Chart
Labeler?

Thanks again!

-----Original Message-----
Thanks for that - very thorough! Is there not a quicker
solution?

-----Original Message-----
Take a look at Jon Peltier's Broken Y axis example.

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

"NOKIA" wrote in
message
news:2564B7F7-0693-4A7E-A5C8-
...
How do you show two value ranges of the same data on
one axis? (the axis
range is separated by a zigzag/heartbeat style line).
e.g. instead of
showing
0-50, the axis could show 10-25 and 40-45.

Any help appreciated!


.

.

Thanks for all your help - I can now complete the task!
Thank you.
-----Original Message-----
Select TOOLS, XY Chart Labeler, Add Chart Labels.

If you don't have the XY Chart Labeler on your list of
tools, you'll have to
select it using the ADD-INS menu on the TOOLS menu.

wrote in message
...
Having worked through the example and downloaded the
relevant add-in, how do you 'add the labels in H2:H13 to
the Markers series along the Y axis' using the Chart
Labeler?

Thanks again!

-----Original Message-----
Thanks for that - very thorough! Is there not a quicker
solution?

-----Original Message-----
Take a look at Jon Peltier's Broken Y axis example.


http://www.peltiertech.com/Excel/Cha...okenYAxis.html

"NOKIA" wrote in
message
news:2564B7F7-0693-4A7E-A5C8-
...
How do you show two value ranges of the same data on
one axis? (the axis
range is separated by a zigzag/heartbeat style
line).
e.g. instead of
showing
0-50, the axis could show 10-25 and 40-45.

Any help appreciated!


.

.



.