![]() ![]() ![]() 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 |