break in x- axis

superoxide · May 15th, 2002, 03:41 PM

I've seen lots of questions regarding this, but no answer. Please Help! I have a series of data points (time in hours) on the x-axis. They range from 1 to 30 with a point for each hour, with a y value data point (let's say mass) for each time point. I have generated a curve based on the mass for time points 1-5 hours. The remainder of the time points (6-30) shows no difference in mass. How do I put a break in the x-axis so that I can show the curve (time points 1 thru 5), using an x-axis scal for these time points only, AND put a break to the final time point (30 hours) without showing time points 6 thru 29 and without adjusting the scale on the x-axis for thirty time points? Sorry if my request is unclear, and I would welcome any feedback. Thanks!

Jay Petrulis · May 15th, 2002, 03:48 PM

Tushar Mehta has a "broken y-axis" example on his website.

http://www.tushar-mehta.com

Possibly you can adapt this to your needs.

HTH,
Jay

superoxide · May 15th, 2002, 03:54 PM

I think it should help! Thanks Jay!

Yaw · Feb 17th, 2005, 08:12 PM

I need help in showing breaks in plots with gaps in the x-axis similar to what "superoxide" posted in May, 2002. Have tried attempting to adapt Jon Peltier's & Tusher - Metha's approaches for handling the y-axis breaks without success.
Can some help me out, as am in a tight corner. Any idea or suggestion will be mostly appreciated.

Feb 17th, 2005, 08:12 PM	#4
Yaw New Member Join Date: Feb 2005 Location: Birmingham Posts: 1	Break in X-axis I need help in showing breaks in plots with gaps in the x-axis similar to what "superoxide" posted in May, 2002. Have tried attempting to adapt Jon Peltier's & Tusher - Metha's approaches for handling the y-axis breaks without success. Can some help me out, as am in a tight corner. Any idea or suggestion will be mostly appreciated.

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

May 15th, 2002, 03:41 PM	#1
superoxide New Member Join Date: May 2002 Posts: 2	I've seen lots of questions regarding this, but no answer. Please Help! I have a series of data points (time in hours) on the x-axis. They range from 1 to 30 with a point for each hour, with a y value data point (let's say mass) for each time point. I have generated a curve based on the mass for time points 1-5 hours. The remainder of the time points (6-30) shows no difference in mass. How do I put a break in the x-axis so that I can show the curve (time points 1 thru 5), using an x-axis scal for these time points only, AND put a break to the final time point (30 hours) without showing time points 6 thru 29 and without adjusting the scale on the x-axis for thirty time points? Sorry if my request is unclear, and I would welcome any feedback. Thanks!

May 15th, 2002, 03:48 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Tushar Mehta has a "broken y-axis" example on his website. http://www.tushar-mehta.com Possibly you can adapt this to your needs. HTH, Jay

May 15th, 2002, 03:54 PM	#3
superoxide New Member Join Date: May 2002 Posts: 2	I think it should help! Thanks Jay!