If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Value Axis Scale Change Problem | dp_fulcher | Charts and Charting | 1 | October 19th, 2004 01:21 PM |
Excel Charts - Value Y axis scale - locking values to preventchanging | Andy Pope | Charts and Charting | 0 | June 22nd, 2004 04:31 PM |
Axis to scale | JT | Charts and Charting | 1 | April 21st, 2004 12:04 AM |