How to add another y-axis range into chart?

's Computer Specifications

Does anyone have any suggestions on how to add one scale on right y-axis and
one scale on left y-axis?
Thanks in advance for any suggestions
Eric

's Computer Specifications

Hi,

In order to have 2 y-axis you require a minimum of 2 data series.
Select the second data series and via the Format dialog set the series to
the Secondary axis.

This explains how to enable the secondary y axis when only 1 series is
required.
http://www.andypope.info/tips/tip005.htm

You can not use the 3d styles if you want dual axis.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Eric" <(E-Mail Removed)> wrote in message
news:6E46F139-B150-4B44-892F-(E-Mail Removed)...
> Does anyone have any suggestions on how to add one scale on right y-axis
> and
> one scale on left y-axis?
> Thanks in advance for any suggestions
> Eric

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
chart x axis labels show up as range	Robert H	Microsoft Excel Programming	1	12th Dec 2008 08:47 PM
chart SLOW when axis range fixed	iml04@hampshire.edu	Microsoft Excel Discussion	0	18th Mar 2007 07:32 PM
range variables for chart x axis values	=?Utf-8?B?Z3Zt?=	Microsoft Excel Programming	2	18th Nov 2005 05:15 AM
Chart, X-axis range	Richard Evans	Microsoft Excel Discussion	6	11th Jun 2004 09:15 PM
Help with chart x axis range	scecilia	Microsoft Excel Charting	1	9th Apr 2004 04:35 PM