As you can see, a secondary axis that displays the variance in percentages has been added, thus showing you a trend. The primary axis displays the target and actual data. Right click one of the horizontal grid lines and select delete. Enter 2500 under major units and select thousands next to Display units.ġ1. Select OK, now right click on the Primary axis and select Format Axis.ĩ. Before you can create a regression line, a graph must be produced from the data. This is done by fitting a linear regression line to the collected data. Select line with markers under chart type for variance.Ĩ. This fact can be used to calculate the concentration of unknown solutions, given their absorption readings. Right click on one of the variance series and select Change Series Chart Type.ħ. Select Format Data Series, then select Secondary Axis.Ħ. Right click on one of the variance series on the chart.ĥ. Then under series options, select series variance.Ĥ. Right click on one of the series on the chart, and select format data series.ģ. Select the entire data range ( A2:D14) then press F11 to create a quick chart.Ģ. Note: You are welcome to download the workbookto practice.Īpplies To: Microsoft ® Excel ® 2007, 20.ġ. In our practice exercise we are going to display the sales target and actual data on the primary axis as values, and the variance as a percentage on the secondary axis. However, should there be different units of measure in your data, a secondary axis will be required, thus allowing you to create a dual chart in your Microsoft ® Excel ® workbook. This works if there is only one unit of measure in the data. Charts by default display a primary vertical axis when created.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |