Click "Insert", and then in the charts section, I will click the waterfall icon, and then click the waterfall chart type. Excel will know to use the entire data range. To create a waterfall chart, I will click any cell within this table. And you can see here that I have a cash flow, I have the starting balance, then cost for materials and labor, then sales revenue related to this project, and then overhead, and finally a total. This workbook has three worksheets and I am starting on the waterfall worksheet. My sample file is the "New charts workbook", and you can find it in the chapter seven folder of the exercise files collection. In this movie, I will show you how to create all three. Waterfall charts for visualizing cash flows, funnel charts for showing the results of a sales process, and mapping for summarizing geographic data. Excel 2019 includes three new types of charts that you can use to summarize your data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |