Excel File Recovery

Sparkline – Mini Chart to Show Data Trends in Your Excel Worksheet

Chart in Excel will occupy a large area in Excel interface. Hence, you can use a tiny chart called sparkline to reflect the tendency of data instead. You can create a sparkline in a cell, and this graphic will not take up a large area in the interface. For example, now you need to display the tendency of the sales volume, you can use the sparkline in this worksheet. Add a Sparkline Click a cell where you want to put the sparkline. Next click the tab “Insert” in the ribbon. ...

Read more »

How to View Two Worksheets Side by Side in Your Excel

Sometimes you need to check values in two different worksheets. Here we will present a method to view two worksheets simultaneously. The two worksheets may be in the same workbook or in two independent workbooks. You can view two sheets together by the method below. View Two Worksheets in the Same Workbook In this part, we use the worksheets in the same file as an example. You can see in the image below that we need to check the values in the two worksheets. Click the tab “View”...

Read more »

How to Present Your Sales Target in an Elegant SmartArt Graphic in Excel

There are many different ways to present the data of sales target in Excel. In this article, we will use the SmartArt in Excel to finish this task. Suppose you have made the sales target of November. You have made the plan according to the actual sales volume of the last month. It is very common to present those data and information in cells. However, you can also input the information into a SmartArt graphic to make the interface more intuitive. Create a SmartArt Graphic In this part,...

Read more »