Out Of This World Excel Plot Multiple Lines On Same Graph

It would be easy if each category was defined in a particular column but in this dataset all categories are in one column.

Excel plot multiple lines on same graph. 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. Create a chart sheet that you want to place all embedded charts into it. By Default Sales and Temperature have been created as Bar Charts and Discount was created as a line Chart.

Red yellow and green. Add a second data series from another sheet. Select and copy the weekly data set select the chart and use Paste Special to add the data to the chart below right.

The chart below contains 3 lines. Then double click the Y axis set the scale minimum and maximum to 0 and 1 and the major unit to 03333333 ie one-third for three panels. From the pop-down menu select the first 2-D Line.

Below is the chart Microsoft Excel inserted by Default. Select combo from the All Charts tab. The first step of creation of the panel chart shows that were on the right track.

From the above chart we can observe that the second data line is almost invisible because of scaling. Then right click the red column in the chart select Change Series Chart Type. This approach is subject to the same limitations as in Excel 2003.

Navigate to Insert - Charts-Combo-Clustered Column-Line on Secondary Axis. Now click on Insert Tab from the top of the Excel window and then select Insert Line or Area Chart. Right click the chart and choose Select Data from the pop-up menu or click Select Data on the ribbon.