Excel Chart With Two Y Axis
Excel Chart With Two Y Axis. Click and drag to highlight all the data you want to graph. The primary Y axis has positive numbers, the secondary Y axis has negative numbers.
For the newer versions of Microsoft Excel, the steps are slightly different. Create a spreadsheet with your data. As discussed earlier, the Dual Axis Line Chart is great for comparing two data sets with very different ranges.
In this chart I have two series (lines that run across the chart).
Here is how to add a secondary axis: Double-press with left mouse button on one of the two data series in the chart to open the task pane.
Download an image of your Chart Studio graph by clicking EXPORT on the toolbar. This section will outline how to make a graph with two Y-axis in Excel using the ChartExpo add-in. Select the data you want to graph.
Rating: 100% based on 788 ratings. 5 user reviews.
Lloyd George
Thank you for reading this blog. If you have any query or suggestion please free leave a comment below.
0 Response to "Excel Chart With Two Y Axis"
Post a Comment