Recommendation Pivot Chart With Two Y Axis

The Axes command on the Add Chart Element menu in Excel provides access to a submenu of that let you add remove and control the scaling of the horizontal and vertical axes for your chart simply by choosing the command that corresponds to the axis placement and scaling you want.

Pivot chart with two y axis. Format the secondary horizontal axis so it uses the same gray line color as the primary horizontal axis. An Axis Title to the left of the graph should appear just overwrite Axis Title with the text that youd like to see. 236 Get the Workbook.

To create one chart for this data follow these steps. If you drag the Amount field to the Values area for the second time Excel also populates the Columns area. Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart group.

The Primary Horizontal and Primary Vertical commands on the Axes. Click the checkbox next to any other lines you want to add to the Y-axis. To swith X and Y axis in pivot charts right click on the pivot chart and click Select Data.

Country field to the Rows area. To add other lines to the Y-axis click the checkbox below Y-axis to the right of the data series in the lower-right corner of the window. For example if you have two too different data eg volume and price which you want to see in one chart.

In fact this proved to be a real nightmare when one could expect this to be. First insert a pivot table. Somendra Misra Excel Ninja.

For instance I want to add a secondary axis to show Legend series of Sum of Profit. Create a Chart with Two-Level Axis Label Based on Pivot Table. You can also create a Column Chart with two-level axis labels based on a pivot table in your worksheet just do the following steps.