Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Claire4Golf
 
Posts: n/a
Default In a 2 Y-Axis chart, how do I assign data ranges to an axis?

I have created a 2 Y-Axis chart with 12 data ranges. Numerically, the first
8 data ranges belong on the 1st Y Axis, and the last 4 data ranges belong on
the 2nd Y Axis, but MS is choosing to put the first six on the left Y Axis
and the last six on the right Y Axis.

I need for the chart to display 8 on the left Y Axis and 4 on the right.
Please advise.

Thank you
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

I find it best to ignore the "built-in custom" types because they do what they want.
The following process works on either the normal or built-in custom types.

Double click a series, and on the Axis tab, select primary or secondary as needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Claire4Golf wrote:

I have created a 2 Y-Axis chart with 12 data ranges. Numerically, the first
8 data ranges belong on the 1st Y Axis, and the last 4 data ranges belong on
the 2nd Y Axis, but MS is choosing to put the first six on the left Y Axis
and the last six on the right Y Axis.

I need for the chart to display 8 on the left Y Axis and 4 on the right.
Please advise.

Thank you


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line chart or scatter chart?? rmellison Charts and Charting in Excel 17 February 10th 10 12:03 PM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"