﻿ excel make chart with 2 y axis

# excel make chart with 2 y axis

When Excel determines the axis values it will use to represent your data in a chart, the values are evenly distributed. For Example: If you plot the following series in an Excel Line Chart. This Excel tutorial explains how to create a chart with two y-axes and one shared x- axis in Excel 2007 (with screenshots and step-by-step instructions). Customizing axes in Excel charts. For most chart types, the vertical axis (aka value or Y axis) and horizontal axis (aka category or X axis) are added automatically when you make a chart in Excel. How To Create Excel Chart With Two Y Axis | Dedicated Excel.How To Make A Chart In Excel (with Pictures) - Wikihow. Displaying Percentages As A Series In An Excel Chart - Techrepublic. Applies To: Excel 2016 Word 2016 PowerPoint 2016 Excel 2013 Word 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 ExcelClick Design > Change Chart Type. On the All Charts tab, choose Combo, and then pick the Clustered Column - Line on Secondary Axis chart. Two Methods:Adding a Second Y Axis Changing the Chart Type of the Second Data Set Community QA. It can be very helpful to put multiple data trends onto one graph in Excel. But, if your data has different units, you may feel like you cant create the graph you need. In order to create an Excel chart with 2 y-axis or x-axis, open your Excel document.After that, right-click on columns and choose change series chart type. Select Line chart. Now you know how to create a chart with 2 y-axis or x-axis in Excel. Last Modified: 2012-05-09. Excel Charting with two y axis.I want the the 0 of dollars and 0 of percents to lign up so that all negatives are below the X axis. Ive tried using the Horizontal Axis Crosses: but it doesnt seem to affect the graph. Click the x-axis or y-axis directly in the chart and then click Horizontal Axis or Vertical Axis on its drop-down list. Excel surrounds the axis you select with selection handles. can I make the vertical axis the category axis in Excel line graph. Column chart - category axis - make to start with the second label.