Spectacular Excel Graph With Two Lines

Click on the empty area and select.

Excel graph with two lines. As before click Add and the Edit Series dialog pops up. In order to add two trend lines youll need to have data for more than one thing like the performance of two or more sales people instead of a single store. To begin with add to the spreadsheet one more row containing monthly revenue.

The chart below contains 3 lines. Multi-colored line chart with multiple series. Using the skittle floating beside the chart Excel 2013 and later or the Axis controls on.

Select the chart type you want for each data series from the dropdown options. So lets assign the weekly data to the secondary axis below left. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value.

In the Format Data Series dialog click Series Options option and check. Right click the Secondary series choose Format Series or similar it varies with Excel version and select the Secondary Axis option. One for each color.

Select Series Data. Creating a chart with two trendlines have different things in common. Start with a line chart or a column chart then right click the other series select Change Chart Type from the pop-up menu and select the type you want.

Bar Chart with Line There are two main steps in creating a bar and line graph in Excel. This example uses a combo chart based on a column chart to plot. Excels line charts use the same data for all series in the chart or more precisely for all series on a particular axis.