So, just by changing the format of the chart you can interpret the data easily. Then within the Format box, you need to choose: Then you need to edit your “ Actual” graph by clicking on its series and pressing the CTRL+1 shortcut. Step 3: Under the Charts group, you can choose from a variety of chart types available or select Recommended Charts to let Excel decide the appropriate chart for your data.

Within the Charts tab, click the Edit button (highlighted in blue within Figure 2) to open the Edit menu. Below is the step-by-step tutorial on How to Create a Graph in Excel: Step 1: Select the range of data (B3: C15) in Excel. In summary, this is how to superimpose graphs in Excel:įirst, you need to edit your “ Plan” graph by clicking on its series and pressing the CTRL+1 shortcut. Follow these steps to learn how to format the values used in Data Labels within Excel 2011: Select the chart - then select the Charts tab which appears on the Ribbon, as shown highlighted in red within Figure 2. STEP 10:Select Chart Title and Press Delete. STEP 9:Select Gridlines and Press Delete. STEP 8: Select Solid Fill and Light Blue as color. STEP 7:Right Click Actual Value Bar and Select Format Data Series.

STEP 6:Select Solid Line as Border, Dark Blue as Color, and 2pt as Width. STEP 5: In the Format Data Series dialog box, select Series Overlap as 100%. STEP 4: Right-click on the bar and select Format Data Series. STEP 2: Go to Insert Tab > In the Charts Group, click on the Clustered Column Chart icon.Ī clustered column chart will appear next to the data table. In the options window, navigate to Select Data to change the label axis data. Right-click the graph to options to format the graph. Our goal is to replace the X axis with data from Date Column. STEP 1: Select all the cells in the table. From the image below, you can see that this graph is based on the index column and the Selected Period column. Watch How to overlay two graphs in Excel on YouTube and give it a thumbs-up! In the example below, we have both actual and planned sales amount for each month and you need to plot it on a graph for easy comparison. Keep reading to learn how to overlay charts in Excel! This overlay of graphs may seem like a difficult exercise but it is a very easy process. Overlay Chart will help you to interpret the data at a glance. Whereas, by just changing the format of the Clustered column we can convert it to overlay chart. Comparing the right of each bar will take time and may be prone to errors. If you try to plot Actual vs Target values in form of a Clustered Column in Excel, it will look like this:Įven though, it will get the job done it will be slow to read and difficult to interpret by the users. In this article, you will learn How to Overlay Charts in Excel and easily compare two sets of data in one graph, like actual sales vs target sales results, actual rating vs target rating, etc.

Select data for graph in excel mac