If you have to import from several sheets in the exact same workbook, using named ranges will conserve some steps. If you would like to make your Gantt chart look somewhat nicer, remove a lot of the white space between the bars. The previous step before making the graph is to pick the data you wish to graph. Our assortment of financial calculators incorporate some of the strongest and user-friendly bill reduction and money management appliances it's possible to gain. If you've got two worksheets you would like to work on, and they're in various workbooks, you will have to close one to work on the other. If you delete the workbook, your report won't work and it is not going to be recoverable. It is possible to move the Excel workbook to some other WebI folder, or rename it, but don't delete it.