From the course: Excel Spreadsheet Design: Extreme Makeover

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Bring data to life with charts

Bring data to life with charts - Microsoft Excel Tutorial

From the course: Excel Spreadsheet Design: Extreme Makeover

Start my 1-month free trial Buy for my team

Bring data to life with charts

“

- [Narrator] They say a picture speaks 1000 words, no Excel makeover would be complete without at least one chart, right? The whole of life costing that you're looking at is pretty darn solid, but it could do with some illustrative flare. I should add, I strongly recommend collaborating with your stakeholders throughout this part of the process, as it will lead to even better end results. Now, there are seemingly endless possibilities when it comes to charting, but having a look at the summary tab here, I reckon a pie chart that dissects the purchase price from the total running cost would look pretty awesome. So go ahead and select cells B7 through to C9 and then go to insert and from the dropdown box next to the pie charts, select 2D pie. Now go ahead and customize the chart to your liking. I like chart style three, and I'm also going to change the layout to quick layout two. Now let's go ahead and move and resize…

Contents