Excel charts

damo · May 23rd, 2002, 11:02 PM

How do you break an axis so that instead of showing all values from 1-1000 you show data from 1-200 and then 800-1000 with the centre portion not displayed?

[ This Message was edited by: damo on 2002-05-23 22:04 ]

PDuPre' · May 24th, 2002, 06:56 AM

Are you sure that's possible?

JayKay · May 24th, 2002, 08:03 AM

Hi Damo

Excel only plots data that is in 'visible' cells within the source data range. Therefore, hiding the entire rows or columns containing the source data entries that you do not want to display should remove them from the graph.

This may not work with all chart types, but the bar and line charts variants should work OK.

The format of the 'axis lables' is also a factor. With text and numeric labels it should work OK but dates / times will cause problems. If you need to then you can get around this by converting the date / time entries to text.

Cheers

Jaykay

Jay Petrulis · May 24th, 2002, 09:07 AM

Check Tushar Mehta's website for an example of this. In the tutorials section, there is one titled, "Broken y-axis" which you may be able to modify to your needs.

http://www.tushar-mehta.com

HTH,
Jay

JayKay · May 24th, 2002, 09:25 AM

Hi Damo

Sorry, thought you were refering to hiding items on the x-axis...

JayKay

Jay Petrulis · May 24th, 2002, 09:33 AM

Quote:

On 2002-05-24 08:25, JayKay wrote:
Hi Damo

Sorry, thought you were refering to hiding items on the x-axis...

JayKay

JayKay,

Why apologize? No need, as your answer was relevant. There is no guarantee that Tushar's example will work without some trial and error. All we did was give the OP some hints/information. Damo will come back with any subsequent questions.

Bye,
Jay

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 11:02 PM	#1
damo New Member Join Date: May 2002 Posts: 1	How do you break an axis so that instead of showing all values from 1-1000 you show data from 1-200 and then 800-1000 with the centre portion not displayed? [ This Message was edited by: damo on 2002-05-23 22:04 ]

May 24th, 2002, 06:56 AM	#2
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	Are you sure that's possible?

May 24th, 2002, 08:03 AM	#3
JayKay New Member Join Date: May 2002 Location: Leicester, UK Posts: 40	Hi Damo Excel only plots data that is in 'visible' cells within the source data range. Therefore, hiding the entire rows or columns containing the source data entries that you do not want to display should remove them from the graph. This may not work with all chart types, but the bar and line charts variants should work OK. The format of the 'axis lables' is also a factor. With text and numeric labels it should work OK but dates / times will cause problems. If you need to then you can get around this by converting the date / time entries to text. Cheers Jaykay

May 24th, 2002, 09:07 AM	#4
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Check Tushar Mehta's website for an example of this. In the tutorials section, there is one titled, "Broken y-axis" which you may be able to modify to your needs. http://www.tushar-mehta.com HTH, Jay

May 24th, 2002, 09:25 AM	#5
JayKay New Member Join Date: May 2002 Location: Leicester, UK Posts: 40	Hi Damo Sorry, thought you were refering to hiding items on the x-axis... JayKay