Casual Chart With Two X Axis
Change a Series Chart Type.
Chart with two x axis. Using two axes in the one chart. Following the below steps you will find that making two y axes in chart is very easy. For example you can create two plots that have different x - and y.
Select the source data and then click the Insert Column Chart or Column Column on the Insert tab. This approach works with chart types that have an Category type category X axis that is. Trace 1 xaxis.
After this the actual plot is drawn in a second axes a located a bit above the other axes and with units kmh. This is pretty easy. Within one of the axes objects move the x -axis to the top of the plot box and move the y -axis to the right side of the plot box.
Only one of those x-axis values is. Then in Format Data Series dialog check Secondary Axis in the Plot Series On. In PowerPoint right-click off the slide choose Layout and choose the Title Content layout.
Here is how to add a secondary axis. To create one chart for this data follow these steps. Please take a look at the screenshot to understand.
Set Up the Source Data. Based on your image the X axis of the two charts is Month Number. Excel 2010 365 2016 2013 2007 2003.