Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"Scale breaks" required in (Z) axis
Hi, I have a chart with the following series: - actual; - budget. However, the (X) axis items have actual and budget ranges which differ greatly. e.g. Item 1 on the (X) axis may have budget and actual values around the 50 mark, whilst item 2 on the (X) axis may have budget and actual values around the 10,000 mark. The challenge is to combine all items, with their vastly differing budget and actual values, onto the one chart. An idea is to have a "scale break" - like a squiggle - which takes out the range on the (Z) axis from 2,000 to 9,000. How can this be done in Excel? I have seen it on charts elsewhere, but do not know how to use in Excel. Can this be done? Thanks in advance for any help on this one. Regards, FH1 -- FH1 ------------------------------------------------------------------------ FH1's Profile: http://www.excelforum.com/member.php...o&userid=23890 View this thread: http://www.excelforum.com/showthread...hreadid=375273 |
#2
|
|||
|
|||
I'm guessing you are looking for something like this:
http://www.peltiertech.com/Excel/Cha...okenYAxis.html "FH1" wrote: Hi, I have a chart with the following series: - actual; - budget. However, the (X) axis items have actual and budget ranges which differ greatly. e.g. Item 1 on the (X) axis may have budget and actual values around the 50 mark, whilst item 2 on the (X) axis may have budget and actual values around the 10,000 mark. The challenge is to combine all items, with their vastly differing budget and actual values, onto the one chart. An idea is to have a "scale break" - like a squiggle - which takes out the range on the (Z) axis from 2,000 to 9,000. How can this be done in Excel? I have seen it on charts elsewhere, but do not know how to use in Excel. Can this be done? Thanks in advance for any help on this one. Regards, FH1 -- FH1 ------------------------------------------------------------------------ FH1's Profile: http://www.excelforum.com/member.php...o&userid=23890 View this thread: http://www.excelforum.com/showthread...hreadid=375273 |
#3
|
|||
|
|||
Thanks Barb R! -- FH1 ------------------------------------------------------------------------ FH1's Profile: http://www.excelforum.com/member.php...o&userid=23890 View this thread: http://www.excelforum.com/showthread...hreadid=375273 |
#4
|
|||
|
|||
It there an easier way to do it?
"Barb R." wrote: I'm guessing you are looking for something like this: http://www.peltiertech.com/Excel/Cha...okenYAxis.html "FH1" wrote: Hi, I have a chart with the following series: - actual; - budget. However, the (X) axis items have actual and budget ranges which differ greatly. e.g. Item 1 on the (X) axis may have budget and actual values around the 50 mark, whilst item 2 on the (X) axis may have budget and actual values around the 10,000 mark. The challenge is to combine all items, with their vastly differing budget and actual values, onto the one chart. An idea is to have a "scale break" - like a squiggle - which takes out the range on the (Z) axis from 2,000 to 9,000. How can this be done in Excel? I have seen it on charts elsewhere, but do not know how to use in Excel. Can this be done? Thanks in advance for any help on this one. Regards, FH1 -- FH1 ------------------------------------------------------------------------ FH1's Profile: http://www.excelforum.com/member.php...o&userid=23890 View this thread: http://www.excelforum.com/showthread...hreadid=375273 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the scale of the catagory axis? | Charts and Charting in Excel | |||
excel page breaks - urgent help required | Excel Worksheet Functions | |||
create a scale x axis that matches the straighted form of a norma. | Charts and Charting in Excel | |||
Locking the scale ratio of X-Y axis in XY scatter charts | Charts and Charting in Excel | |||
secondary axis scale | Charts and Charting in Excel |