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 |
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 |
All times are GMT +1. The time now is 03:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com