HOW TO FORMAT X AXIS IN EXCEL 2010 SERIES
Choose Secondary Axis for the data series “ Profit Margin ”.Select Combo > Cluster Column – Line on Secondary Axis.Select Data Table B1: D7 and Insert 2-D Clustered Column Chart.To add secondary axis Excel 2013 and later versions we need to follow the following procedure while setting up the secondary data series ( Profit Margin ) in 2-D Clustered Column chart. Secondary Axis Excel 2010 Using Excel 2013 and Later Versions Changing Chart Type For Secondary Data Seriesįigure 9. Select the Line Chart type for Excel Secondary Axisįigure 8.Go to Design tab > From Type section click on Change Chart Type.In the Chart Area, click on secondary data series bar ( Profit Margin ).Select Secondary Axis from Plot Series On options.Click on Format Selection in Current Section to open Format Data Series dialog.From Current Selection click on Chart Element drop-down arrow.We need to follow the below steps to add secondary data series ( Profit Margin ) on Y-axis
To add the second Y axis Excel 2010, we must have the 2-D chart secondary axis are not supported in 3-D charts. Creating 2-D Clustered Column Chart Add Secondary Data Series But we need to show “ Profit Margin ” data series on the secondary axis.įigure 4. Selecting 2-D Clustered Column ChartĪ 2-D Clustered Column chart is generated showing “ Months ” in X-axis and Revenue on Y-axis (primary axis). Click on Column and select 2-D Clustered Column Chartįigure 3.Click on Insert tab and go to Charts section.We select the data table B1: D7 and create the 2-D chart in Excel 2010 and earlier versions by following these steps Suppose we have monthly revenue and profit margin data series in terms of dollar amounts and percentages in a table range B1:D7.įigure 2. But when the values of data series vary then we can plot more than one data series on secondary axis Excel. We can create one data series at a time on a secondary axis.
HOW TO FORMAT X AXIS IN EXCEL 2010 HOW TO
How to Add Secondary Axis in Excel Using Excel 2010 and Earlier Versions We will learn how to add secondary axis in Excel based on following versions įigure 1. Excel secondary axis allows us to show two Y-axis data series with two different scales using the same X-axis. When we have two different yet related pieces of information then we need to show them on Y-axis on a single chart. How to Add Secondary Axis in Excel and Google Sheets
0 kommentar(er)
