Fantastic Excel Graph 2 Axis
A horizontal axis or x-axis and a vertical axis or y-axis.
Excel graph 2 axis. For this example Row 3 will be our secondary axis. Through appropriate arrangement of your source data you can give your chart a dual category axis. Click Insert Column 2-D Column Chart.
In the popup menu. For example if you have two too different data eg volume and price which you want to see in one chart. To create one chart for this data follow these steps.
Table of Contents hide. First select the Insert tab from the toolbar at the top of the screen. Sometimes you want to show several axes in one chart to demonstrate each data series with different formatting and with different axis in one chart.
Each number will be listed. Below are the steps to add a secondary axis to the chart manually. Right-click on this chart object and choose Select Data.
In the Charts group click on the Insert Columns or Bar chart option. Adding a secondary axis to this chart. Just do the following steps.
Select the Data to be plottedYou can use this Example Worksheet to practice creating the 2 Axis Chart. It is almost as if you need another line red thick line below to show. For example Wilma wants to compare the CPC to CTR for the last 24 hours in her campaign.