If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Different Secondary X Axis but same Y Axis
I am plotting 2 data sets with different X axes. I would like them to use the same Y axis, but the only way I can figure it out is if I use a primary and secondary Y axis of the same values. This causes me to make a few extra steps is the scaling of the 2 Y axes change...I have to manually go in and change it. My primary data series looks like this: A 10% B 35% C 16% D 44% My secondary data series looks like this 0 75% 1 75% I would like for the secondary data series to use the same Y axis % min/max and the primary. Any thoughts? -- Mutiny_92 |
#2
|
|||
|
|||
You already know how to assign a series to the secondary axis. Once
you've done that, go to Chart Options on the Chart menu, click on the Axes tab, uncheck the secondary Y axis, and check the box for the appropriate type of secondary X axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Mutiny_92 wrote: I am plotting 2 data sets with different X axes. I would like them to use the same Y axis, but the only way I can figure it out is if I use a primary and secondary Y axis of the same values. This causes me to make a few extra steps is the scaling of the 2 Y axes change...I have to manually go in and change it. My primary data series looks like this: A 10% B 35% C 16% D 44% My secondary data series looks like this 0 75% 1 75% I would like for the secondary data series to use the same Y axis % min/max and the primary. Any thoughts? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stacked Bar Chart with Secondary Axis | Benjamin B | Charts and Charting | 7 | May 15th, 2005 04:00 AM |
How do I set permanent secondary axis in PivotTable chart? | Microlong | Charts and Charting | 3 | January 8th, 2005 03:54 AM |
Problem with secondary y axis | Leslie | Charts and Charting | 1 | April 26th, 2004 12:38 AM |
Secondary Y Axis in Excel 2000 | Fred | Charts and Charting | 1 | December 24th, 2003 10:27 PM |
Secondary Y Axis in Ms.Excel | Basix | Charts and Charting | 1 | October 1st, 2003 07:35 PM |