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
|
|||
|
|||
Secondary Axis
How to change where the category (x) axis crosses the value (y) in secondary
axis. There are 2 chart type (bar and line) in the same chart: Primary axis: Bar chart Secondary axis: Line chart |
#2
|
|||
|
|||
Iris -
You can change where the primary X axis crosses the primary Y axis, and where the secondary X axis crosses the secondary Y axis, through the Scale tab while formatting the respective Y axes. To make the primary X axis cross at a given place on the secondary Y axis, you need to adjust the scales of the primary and secondary Y axes together until they cross where you want. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ iris wrote: How to change where the category (x) axis crosses the value (y) in secondary axis. There are 2 chart type (bar and line) in the same chart: Primary axis: Bar chart Secondary axis: Line chart |
#3
|
|||
|
|||
Unfortunately. This doesn't work for me. When I switch the bar graph over to
the secondary axis the other series (flow data) and the bar graph again no longer have the same corresponding xvalues (dates). I solved the problem inelegantly by creating a second x-axis to correspond to the bar graph and setting both x-axis ranges equal before hiding the 2nd xaxis. Because of all the manipulation and a possibility of someone else having to revisit these graphs the solution is certainly not ideal. Any suggestions? Also, how do you make the secondary y-axis max occur at a height lower than the primary y-axis? "Jon Peltier" wrote: Here's what I did. I made the chart with four scatter series, and didn't set any axis min/max yet. I selected the fourth and made it a column type. Then I formatted each of the scatter series to plot on the secondary axis. Excel now decides to make the X axis into a time scale axis. You can double click this and set min and max, and the column chart will obey (so will the scatters). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ tinyred wrote: I am trying to graph 4 series of data. 3 series are scatter plots and are working fine no matter what i do. The other is a bar graph for rainfall data (in). I want to put it on a secondary axis. I am taking a large set of data and looking at only a few days in my range. When I change this series to a bar graph it no longer corresponds to the range selected on the xaxis but shows all the data available. When I put data on the secondary axis as a bar graph, again it does not correspond with the xaxis. How can I make this work? |
#4
|
|||
|
|||
When I switched the column series to the secondary axis, I ran into
difficulties making the secondary axes visible, and I found it easier to keep the column series on the primary axis and switch the others to the secondary axis. The X values (dates) worked out fine with my sample data, using only a single X axis. One scales secondary and primary axes the same way, by double clicking and changing the parameters in the Scale tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ tinyred wrote: Unfortunately. This doesn't work for me. When I switch the bar graph over to the secondary axis the other series (flow data) and the bar graph again no longer have the same corresponding xvalues (dates). I solved the problem inelegantly by creating a second x-axis to correspond to the bar graph and setting both x-axis ranges equal before hiding the 2nd xaxis. Because of all the manipulation and a possibility of someone else having to revisit these graphs the solution is certainly not ideal. Any suggestions? Also, how do you make the secondary y-axis max occur at a height lower than the primary y-axis? "Jon Peltier" wrote: Here's what I did. I made the chart with four scatter series, and didn't set any axis min/max yet. I selected the fourth and made it a column type. Then I formatted each of the scatter series to plot on the secondary axis. Excel now decides to make the X axis into a time scale axis. You can double click this and set min and max, and the column chart will obey (so will the scatters). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ tinyred wrote: I am trying to graph 4 series of data. 3 series are scatter plots and are working fine no matter what i do. The other is a bar graph for rainfall data (in). I want to put it on a secondary axis. I am taking a large set of data and looking at only a few days in my range. When I change this series to a bar graph it no longer corresponds to the range selected on the xaxis but shows all the data available. When I put data on the secondary axis as a bar graph, again it does not correspond with the xaxis. How can I make this work? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with secondary y axis | Leslie | Charts and Charting | 1 | April 26th, 2004 12:38 AM |
P & V chart: Secondary X axis gradient (again) | wlotto | Charts and Charting | 9 | March 15th, 2004 05:26 PM |
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 |