Scroll down the list of commands and find Camera.Ģ.In the Choose Commands From drop-down menu, select Commands Not in the Ribbon. ![]() We start by adding the Camera tool to the quick access tool bar because it is not available on the ribbon. You are welcome to download the workbook to practice.Īpplies To: Microsoft ® Excel ® 2010, 20.ġ. There is no standard Sparkline bar chart, but that can easily be created by using the camera tool after rotating the object. In this example, the column Sparkline chart will be rotated to create a bar chart enabling us to better analyze the YTD variance between budgets and actuals. The picture will automatically update when the data in the original cells change. The camera tool enables you to take a picture of a range of cells and display it in a preferred way, thus allowing you to enhance your dashboards.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |