MS Excel 2007 Create a chart with two Yaxes and one shared Xaxis
Excel Two X Axis. Select the data series which you want to see using the secondary horizontal axis: Add the secondary vertical axis to any of the data series (see how to create two vertical axes on the same side ).
Web adding a second horizontal x axis in excel can be handy when you want to show two different sets of data for different time ranges. Select the data series which you want to see using the secondary horizontal axis: And inside the series options tab choose secondary axis. Select secondary axis for the data series you want to show. Add the secondary vertical axis to any of the data series (see how to create two vertical axes on the same side ). Web select design > change chart type.
Select the data series which you want to see using the secondary horizontal axis: Select the data series which you want to see using the secondary horizontal axis: Select secondary axis for the data series you want to show. And inside the series options tab choose secondary axis. Web adding a second horizontal x axis in excel can be handy when you want to show two different sets of data for different time ranges. Web select design > change chart type. Add the secondary vertical axis to any of the data series (see how to create two vertical axes on the same side ).
