Create a break in Y-axis values

's Computer Specifications

Hello group!

I have a chart with values ranging from 3 to 3.5 million.

I have charted it using a logarithmic scale, but would
prefer to use a Y-axis with a break in it.
Have seen these all over the place, but have never seen it
done in Ecxel.
Is this pocssible? If so how?

Thanks in advance
Meg

's Computer Specifications

Jon Peltier has instructions for a broken Y axis:

http://www.peltiertech.com/Excel/Cha...okenYAxis.html

Meg wrote:
> I have a chart with values ranging from 3 to 3.5 million.
>
> I have charted it using a logarithmic scale, but would
> prefer to use a Y-axis with a break in it.
> Have seen these all over the place, but have never seen it
> done in Ecxel.
> Is this pocssible? If so how?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Placing an Axis Break on the Y axis	Wrangler	Microsoft Excel Charting	1	29th Dec 2007 09:29 AM
How to create 2 line graph with XY axis values in Power Point	=?Utf-8?B?Q0FC?=	Microsoft Powerpoint	0	25th May 2007 03:17 PM
how do you create a trendline for only the x-axis values in excel	=?Utf-8?B?aGVscA==?=	Microsoft Excel Charting	1	6th Oct 2006 11:12 PM
How to insert X axis scale values next to axis and X axis grid lin	=?Utf-8?B?dnAyM2xhcnJ5?=	Microsoft Excel Charting	2	23rd Jun 2005 03:45 PM
Hiding Values Below Z Axis Minimum Value on Axis Charts	=?Utf-8?B?VHJ5aW5nVG9FeGNlbA==?=	Microsoft Excel Charting	1	18th Feb 2005 03:55 AM