Smart Chart In Excel With 2 Y Axis
Create a Column Chart.
Chart in excel with 2 y axis. This will open the Insert Chart dialog box. See also this tip in French. Most chart types have two axes.
Click the Insert tab. The Format Data Series dialog box. Add the secondary vertical axis to any of the data series see How to create two vertical axes on the same side.
Scan the charts in the left pane and select the one that has a secondary axis. Excel puts it at the top of the chart by default. On the Chart Design tab in the Chart Layouts group click the Add Chart Element drop.
To make any graph with two Y-axis in Excel you need to start with a spreadsheet. From the Format tab Current Selection Group check you have the correct data series selected and then click Format Selection. A horizontal axis or x-axis and a vertical axis or y-axis.
Bring your cursor to the chart and click anywhere. Select the data series which you want to see using the secondary horizontal axis. Creating Multiple Y Axis Graph In Excel 2007 Yuval Ararat.
Format the secondary horizontal axis so it uses the same gray line color as the primary horizontal axis. This example is on 2 axes and the steps are shown below. For example Wilma wants to compare the CPC to CTR for the last 24 hours in her campaign.