Neat Secondary Horizontal Axis
Combining several charts into one chart.
Secondary horizontal axis. This combination chart now allows you to see the variation in both series of data. After creating the stacked column I move on creating the xy. The vertical axis on the left that represents the measured values also known.
It is almost as if you need another line red thick line below to show where the secondary axis crosses at 0. After you add a secondary vertical axis to a 2-D chart you can also add a secondary horizontal category axis which may be useful in an xy scatter chart or bubble chart. A secondary axis is required when you have to compare two distinct types of series on the same charts mostly whole values and percentages.
Thus two gaps above 0 and four gaps below zero. The axis that contains the categories of the data also known as the x-axis. If not add it temporarily so the secondary vertical axis crosses at the automatic position which is at zero.
Alternatively you could format the primary horizontal axis and make the primary vertical axis cross at the maximum. Hope I could explain the porblem. This does not serve the purpose.
While the secondary vertical axis provides a way to display two different types of data for the one time range the secondary horizontal axis allows you to create a. The automatic secondary axis boundaries go from 100 to -200 with gaps major units of 50. If one of the datasets is plotted on a bar chart the horizontal axis shows the values instead of the categories.
Id like the horizontal axis to hit zero on both the the primary and secondary axis so the secondary axis and the negative numbers should hang below the graph if you know what I mean. Boone To get a dollar sign in a number format you just type it into the format eg 000. 1 Add secondary axis to Excel charts the direct way You can add the secondary axis to an Excel chart from the beginning when youre making the chart.