In this article we will learn how we can make waterfall chart in Microsoft Excel 2010.
Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Excel 2013, Excel 2010, Excel 2007,. Launch Excel 2010, and open a datasheet on which you want to apply VLOOKUP function. For instance, we have included a student grading datasheet, containing fields; Name, Course, and Marks. Now we will add new column Grade, which will contain grades secured by the students. Now for this, we will be using VLOOKUP function for looking up values.
This chart is also known as the flying bricks chart or as the bridge chart. It’s used for understanding how an initial value is affected by a series of intermediate positive or negative values.
How to open the VBA environment. You can access the VBA environment in Excel 2010 by opening the Microsoft Visual Basic for Applications window. First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc. Keep in mind that the Formatting toolbar in Microsoft Excel 2010 is exactly the same as the one used for Microsoft Word 2010. The biggest difference between the two programs is that, in Excel, the format is set for eachindividualcell.
You can use this chart to show the revenue and expenditure of a business or even personal accounts.
Let’s take an example and understand how and where we can use this chart and how it will perform if we present the information in Water Fall Chart.
We have a data set where we have the revenue, cost of sales, etc. Now let’s insert another column before column B and enter “Remaining Profit” as the title.
Microsoft Word Excel 2010 Free Download
This is calculated as follows
- First we minus cost of sales from revenue earned.
- So 2 million minus 4 hundred thousand gives us 1.6 million.
- We get the same figure as the gross profit.
- Then from this figure, we keep deducting each cost – management costs, cost of sales, operating costs, etc.
- So we minus 240000, 180000, 300000 and 400000 from 1600000 to get our net profit of 480000.
Now we just need to plot this and we will come up with an interesting looking waterfall chart.
- We need to start with a stacked column chart and then alter it to suit our needs.
- So we select our data, then go to Insert tab and select stacked column chart.
- Remove the legend as we do not require it.
- Now click on one of the blue columns which will result in all the blue ones being selected.
- Right click and select Format Data series. Click on the Fill & Line option and select No fill under Fill. Under Series options, change the gap width to 0%.
It’s almost done. Just a few things are left. Change the fill color of revenue earned, gross profit and net profit to a green. Now you can change the scale, add data labels, etc and format it further.
That’s it, a simple waterfall chart. This can be really useful when you want to include it in your reports and show data from a different angle.
Popular Articles:
- Microsoft excel 2010
Most people looking for Microsoft excel 2010 downloaded:
DownloadTake your skills to the next level with tables, formulas, formatting and more.
DownloadMs Excel 2010 Free Download Filehippo
Microsoft Office Professional 2010 brings together our top-of-the-line tools to help you stay organized, connected, and competitive.
DownloadThe Microsoft Excel Viewer allows people who do not have Microsoft Excel to view Excel workbook files.
DownloadWith Acrobat Reader DC, you can do even more than open and view PDF files.
Ms Excel 2010 Tips
DownloadSecurity Update for Microsoft Office Excel 2007 (KB982308) is a tool that resolve the vulnerability that may appear in Microsoft Office 2007.
Similar choice