﻿ how to plot graph with two y axis in excel 2010

# how to plot graph with two y axis in excel 2010

Most graphs in Excel 2010 use a numerical vertical axis and a categorical horizontal axis, which can make it difficult if you are trying to plot a series of coordinates.How to Make a Skew Graph in Excel. My X-axis is year 2000-2010 and I need to plot house prices up one Y-axis and Volume of sales up the other Y-axis so the two can be compared on the same graph. I am having trouble doing this, can anybody help me? dom brassey says. 19/10/2010 at 12:16 pm. In Outlook 2007 I think you cannot do this with any of the 3D graphs. The Plot Series On: Secondary Axis option simply does notBut more than 2 y axis is not possible with excel 2007, If you know how to have more than two y axis in excel pl let me know. : Most Active Software Boards. : LabVIEW. : How to set 2 Y-Axis on a Excel Graph.I am trying to make an excel XY plot with 2 y-axes, I am using report generation VIs for this program. Plot Multiple Data Sets On The Same Chart In Excel 2010. How To Make A Line Graph In Excel (scientific Data). Charts In Excel - Dual Axis Chart. Create A Combination Chart. How to Make a Line Graph on Excel 2010. 9. Type Data into Excel Spreadsheet.Click on scatter plot smooth line 14. Fill in Chart title, x axis and y axis by clicking on layout under chart tools in the. In excel, click chart, pick scattrer, pick any you want, click next, selet series, add series, and you can choose the x - axis and y-axis.

You can add more series, and name them differently. Click next and follow it, place it in a new chart, nice to look at.that way. Excel - how to plot a line graph with 2 vertical y-axis.Excel Magic Trick 92: Two Chart Types In One Chart! See how to: Add Data Series To Chart, Change theDescription: Shows how to create a chart with clustered columns in Excel 2010, delete rows or columns, and switch rows and columns. Last Modified: 2014-01-23.