Excel File Recovery

How to Easily Create a Step Chart in Your Excel Worksheet

Among all of the charts in Excel, the step chart in Excel can clearly show the data changes. In this post, let’s see how to create this kind of chart. A step chart in Excel has a wide range of use. In an ordinary line chart, you can only know the trend of data. But in the step chart, you can know the detailed changes of the numbers. Below we will show you how to create such a chart. Arrange the Range Now we will use this sample to create a step chart. Rearrange the range in the...

Read more »

How to Read Data from Online Web Pages with Excel VBA

This exercise shows how to read data from a website, in this case up-to-the-minute currency exchange rates from Yahoo.com. It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window". Prerequisites include a knowledge of populating combo-boxes and defining names. The workbook consists of two sheets: The User Interface: The Buy and Sell combo boxes reference the local data sheet...

Read more »

How to Create and Use Your Own Excel Add-Ins

Excel add-ins can provide plenty of additional features for you. You may even create and use your own add-ins for your Excel. So now let’s see how to realize this. There are numerous Excel add-ins available in the market. If you need to use Excel to finish your tasks quite often, you might have already utilized certain add-ins. On the other hand, even though the add-ins are beneficial, they cannot meet all the requirements. Therefore, you can create your own add-ins for your Excel. Follow...

Read more »