Adding broken y-axis to graph

flamingrill · May 8th, 2002, 12:48 PM

I have a range of values that fall on the extremes. I wanted to create a broken y-axis or a break indicator and can't find how to do it on an excel graph. Any help would be appreciated!

Corticus · May 8th, 2002, 01:36 PM

try using a logamarithmic instead of arithmentic scale (its in the axis properties under format axis- scale))for your axis, then have Excel auto-determine the range(or not, helps though).

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

May 8th, 2002, 12:48 PM	#1
flamingrill New Member Join Date: May 2002 Posts: 1	I have a range of values that fall on the extremes. I wanted to create a broken y-axis or a break indicator and can't find how to do it on an excel graph. Any help would be appreciated!

May 8th, 2002, 01:36 PM	#2
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	try using a logamarithmic instead of arithmentic scale (its in the axis properties under format axis- scale))for your axis, then have Excel auto-determine the range(or not, helps though).