LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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?
 
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
Secondary Axis Match Primary Axis Gridlines [email protected] Charts and Charting in Excel 1 July 31st 05 09:23 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM
secondary axis scale Kent Smith Charts and Charting in Excel 3 January 4th 05 07:37 PM


All times are GMT +1. The time now is 06:54 PM.

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

About Us

"It's about Microsoft Excel"