The actual graph representing the selected data is displayed in the middle. If you set the increment of the two x-axes to two different values, this graph can be even more confusing.A standard graph in Excel consists of different elements. Notice also that I set both x-axis to start, stop, and increment at the same values. The blue y-axis runs from 0 to 90, while the red y-axis runs from 0 to 100. Notice that the two y-axes have different scales. I changed the color of the text of the upper x-axis and the right y-axis to red to signify their use for the red series. I purposely changed the color of the text of the lower x-axis and the left y-axis to blue to signify that these are the axes to use for the blue series. That will assign the selected series to a secondary x-axis.īelow is an example. Click "Secondary Horizontal Axis" and pick whatever options you want. That will assign the selected series to a secondary y-axis.Ģ) With the series still selected, go to the "Chart Tools" "Layout" "Axes" selection on the ribbon. Under "Series Options" select "Secondary Axis". Here are the steps:ġ) Right click on the series that you want to assign to the secondary axes. It requires that you assign one (or more) of the lines to a secondary y-axis and then a secondary x-axis. However, I wouldn't recommend this scheme because it is typically too confusing for others to interpret the results.
There is a second way to do this where the blue series has its own x-axis and y-axis, and the red series has a different x-axis and y-axis. When I select Temp 2, the corresponding graph formula is: They are both plotted in the graph.Īs shown in the plot, the blue Temp 1 has been "selected" in the graph and the corresponding graph formula is: Temp 2 starts at 9:30:00 AM and increments by 2 minutes and 53 seconds. Temp 1 starts at 9:00:00 AM and increments by 1 minute and 26 seconds. Below is a screenshot of an Excel sheet where two temperatures are shown. Use a Scatter Plot where the horizontal axis is time.
0 kommentar(er)
