PC Review


Reply
Thread Tools Rate Thread

display value axis on both sides

 
 
=?Utf-8?B?cGF1bHQ=?=
Guest
Posts: n/a
 
      16th Mar 2006
I'm trying to display the y axis on both the left and right side of the
chart; is this possible, and if so, how to i go about it? thanks.
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      16th Mar 2006
This requires having a primary and secondary axis. The minimum requirement
here is to have two series. The best way to manage this is to add a range to
the worksheet using, say, the first two X values for X, and the minimum and
maximum values in all of your Y data for Y. Add this range to your chart as
a new series. If your main chart is a column chart, change this series only
to a line chart type (Chart menu > Chart Type); otherwise use the same type
as exists in the chart. Double click on this new series, and first, on the
axis tab, choose Secondary. Then on the Patterns tab, hide the series by
choosing None for line and marker.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"pault" <(E-Mail Removed)> wrote in message
news:8423584A-6C52-4A16-AA69-(E-Mail Removed)...
> I'm trying to display the y axis on both the left and right side of the
> chart; is this possible, and if so, how to i go about it? thanks.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
axis titles on both sides =?Utf-8?B?QWRhbQ==?= Microsoft Excel Charting 1 26th Jun 2006 10:39 PM
Have Y axis valuse at both sides of a chart jon Microsoft Access 0 12th Jun 2006 08:10 PM
Y-axis on both sides?? Gridlines priority?? germullen Microsoft Excel Charting 2 17th May 2006 05:18 PM
Y-Axis Labels on Both sides... =?Utf-8?B?amdyYXk=?= Microsoft Excel Charting 1 10th Aug 2005 08:41 AM
How to have the Y-axis values on both sides Peter Microsoft Excel Charting 3 23rd Oct 2003 05:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:22 PM.