Can i overlay graphs in excel

Overlaying one chart type onto another in Microsoft Excel is a helpful technique that lets you combine two different ways to present data onto a single graphic. A common use of this in the business world is to overlay a line chart onto a bar chart to display data, such as your company's actual revenue versus projected revenue.

These types of overlays can help communicate changes in the data more effectively than using a single chart type.

Click and drag the range of cells you want to create a chart from. For example, select the cells from A1 to B Click one of the chart types from the Charts group of the Excel ribbon.

Select a specific type of chart from the drop-down list. If two columns of values are selected or a range of two columns , then one data plot displays in each layer.

Each data point in the data plot is connected by a line. The default line connection between points is a straight line. The data points are displayed as symbols. In an Excel chart, can I have different Y - axis scales a primary and secondary axis? Yes, in Excel and Excel you can have two axes. Start by creating a chart with just one axis. Select the data series you wish to place on a secondary axis , by clicking on the series in the chart. If you are in Excel or , it will open the Format Axis dialog.

Then if you want to move the Y axis to the left, check Automatic in the Vertical axis crosses section. Definition of secondary axis. Overlap Graphs in Excel. Overlapping graphs in Excel is used to compare two sets of data in one graph , like Actual v Plan results. This overlay of graphs may seem like a difficult exercise but it is a very easy process. To follow along, use this sample workbook.

Select the data you would like to use for your chart. Go to the Insert tab and click Recommended Charts. Click the All Charts tab and select the Combo category. Choose the type of chart you want to use for each data set in the table at the bottom of the Insert Chart dialog.

Select the "Secondary Axis" box for the data you want to move to the secondary axis. Click "OK" to create the combo chart.

Press "Ctrl-S" or click the "Save" button to save the changes to your workbook.