Skip main navigation

New offer! Get 30% off your first 2 months of Unlimited Monthly. Start your subscription for just £29.99 £19.99. New subscribers only. T&Cs apply

Find out more

The Finishing touches

Finishing touches often include formatting. Watch Paula demonstrate more.
That’s come down to our sales by our sales rep. I’ve selected all of the columns. And on all of the columns, I’m going to go to fill and I’m going to select a gradient fill. Now our gradient fill has already selected some colors here for me. But we can go into our gradient fill and you can pick the different color tones that you want to use within your actual columns themselves. And we see this is a 3 color. We can change this to a 2 color if we wanted to change it to a 2 color as well. And we can just say okay to that.
And then I’m going to go to our series options and in our gap width, I’m going to reduce our gap width to only 50%. And that makes the column stand and a little bit more than enough, lot wider than they were originally. I’m going to do the same then with our sales by our products. I’m going to select the bars, and I’m going to select a gradient fill. Now you see here with this gradient fill we have a dark color at each end, and light color in the center. So I’m going to select and change this so that we just have our dark color. So, I’m going to delete this and say okay.
So now, if we go into our series options, and again, we can reduce the gap width and I’m going to reduce the gap width to 50% here as well. Again, it just gives you, allows you to see the bars that little bit clearer than when they were so shortly set up earlier on. So now we have our dashboard nearly finished. What we’re going to do now is insert a text box and in our text box I’m going to select all of these cells appear so it’s easy then to center and align the text. I’m going to call this sales dashboard. I’m going to make this bold. And maybe a little bit bigger. And I’m going to center it.
Then I’m going to make sure that there is no fill on our text box and I’m also going to select format shape and from our format shape I’m going to make sure that there is no border as well. So now we can’t see the border. The final steps then is if we go to our view ribbon and in our view ribbon, we can remove the grid lines from the worksheet as well. Now our dashboard is looking enough, lot more, like dashboards that we had originally. We can select our sales manager and we can see the charts are dating based on the actual sales manager, each of the chart.
So, our total sales chart update our sales by sales rep, and our sales by product. If we take our product category, this also updates all of our charts so I can remove the filter from sales manager. And I can just look at different product categories, but you can look at them in addition to particular sales reps as well. And if you wanted to, you can look at them in conjunction, with particular months of the year, or we could change this to show quarters. So particular quarters of the year. So now what we’re looking at, is the sales for sales manager Linda, we can see all of her sales reps.
We can see the products that they sold, and we can see the total sales for quarter one of 2020 for water sports. We can then look at outdoor, we can look at indoor and we can explore the data as much as what is actually needed. [END]

Apply any finishing touches to your dashboard as required. Once you are happy with it, you can save the file.

Comment below:

What are your main takeaways from this video?

This article is from the free online

How to Use Pivot Tables to Analyse Data in Excel

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now