Looking Good Two Line Charts In One Graph Excel

Multi-colored line chart with multiple series.

Two line charts in one graph excel. Open your first Excel worksheet select the data you want to plot in the chart go to the Insert tab Charts group and choose the chart type you want to make. Select the entire data range A2D14 then press F11 to create a quick chart. It allow you to code javascript in excel merging two charts in one is pretty easy in.

But first we need to add a column to hold our dataor create another small table. Our table example is very simple we will combine revenue expenses and profit. Insert a chart and select the line chart and select the entire table of data and Excel will perform its magic.

Thanks in advance Ian. Fill in entries for series name and Y values and the chart shows two series. After insertion select the rows and columns by dragging the cursor.

There are spaces for series name and Y values. From the above chart we can observe that the second data line is almost invisible because of scaling. Im currently using word art for one of my titles but it doesnt look right.

One for each color. Click here to reveal answer. When you want to display the sets of the same type of data but the ranges vary widely between the two.

Could anyone please inform me if it is possible to have 2 Chart titles on one chart if so how. Then select your first chart that you want to move it to the chart sheet and then right click choose Move Chart from the context menu see screenshot. From the pop-down menu select the first 2-D Line.