Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart or scatter chart?? | Charts and Charting in Excel | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |