Practice Video: Modify Chart Elements

Loading...

Macquarie University의 강좌에서

Excel Skills for Business: Essentials

4214개의 평가

Macquarie University

Excel Skills for Business: Essentials

4214개의 평가

Specialization Excel Skills for Business에서 4의 강좌 1

In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs. Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. We have brought together a great teaching team that will be with you every step of the way. A broad range of practice quizzes and challenges will provide great opportunities to build up your skillset. Work through each new challenge with our team and in no time you will surprise yourself with how far you have come. Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.

수업에서

Charts

Charts are one of the most common ways to present data visually. This module walks you through creating and modifying charts in Excel.

Practice Video: Basic Chart Types: Pie, Column and Line Charts6:13

Practice Video: Move and Resize Charts6:04

Practice Video: Change Chart Style & Type4:32

Practice Video: Modify Chart Elements4:47

Week 6 Wrap-up1:26

강사 만나기

Dr Yvonne Breyer
Program Director, Design and Experience, Global MBA
Faculty of Business and Economics

Now that Sean is confident in styling his chart in Excel,

he also now wants to modify some of these styles.

Here, styling means playing around with the default colors

as well as adding different elements to your chart.

Click on the chart so that the Chart Tools tab comes up.

And now look at the Design tab, and go all the way to the left and

you'll find the Add Chart Element button.

Click on that.

You can add different elements to your chart, such as Axis Titles or Chart Title.

At the moment, our chart does not have a title.

You can see that the button None has already been pressed.

If you now click on Above Chart, guess what?

A chart title appears, except it just says chart title.

Double click on that chart title or highlight all of the letters and

type in an appropriate chart title that you feel suits the data.

Go back to Add Chart element.

Let's add some axis titles.

Click on Axis Titles > Primary Horizontal,

now we can add Account Managers as the horizontal axis name.

Go back to Add Chart Element > Axis Titles > Primary Vertical.

Double click or highlight all of the text to edit it.

Now I'll add sales and

put dollars in brackets as the title for the vertical axis.

So if you want to add a different chart elements remember that you've got to click

on that Add Chart Element button within the design tab.

Another way to modify your chart is by clicking on your chart and

you'll see, when you hover, that three buttons appear on the top right.

The plus does pretty much exactly the same thing as

the Add Chart Element button that we just looked at.

You can check or uncheck whatever options you want to add to your chart.

Click on the Paintbrush icon.

Here, again, you can change the style of your chart, just like we did before.

Or, you can click on color, and

again you can change the color of your chart just like we did before.

Click on the funnel, the filter.

It lets you select which data you want to add or remove from your chart.

Let's say we only wanted to see Mihael Khan's category within this chart.

Uncheck Select all and then check Mihael Khan.

Click Apply.

And now the graph has completely changed to only show the sales figures for

Mihael Khan.

Check Select All again, click Apply, and

now your chart is showing all the figures for the different account managers.

So, another great way to modify your chart is by Clicking on the chart, and

then utilizing these three buttons on the top right.

Plus, a paintbrush icon, as well as a funnel icon.

Another way to modify your chart is by double-clicking your chart.

As you can see, Excel has now brought up a new menu called Format Chart Area.

Here you can click on the drop down menu and

change the chart area, the chart title, the axis and so on.

And for each of these,

you can change the fill in line by clicking on the paint bucket icon.

You can change the effects by clicking on the pentagon icon,

which is actually a paint nib.

Or you can size and change the properties

of the different chart elements by clicking on the Move icon.

Have a play around and see what you can do.

Every single element of your chart: the title,

the legend, the colors of the columns, the axis,

the font of the axis, every single element can be modified.

Have a play around with all of these options and

see how you can modify your chart to really impress your team.

Coursera 카탈로그 살펴보기

무료로 참여해 맞춤화된 추천, 업데이트 및 제안을 받아보세요.

Coursera는 세계 최고의 교육에 대한 보편적인 접근 기회를 제공하며, 최고의 대학 및 기관들과 제휴하여 온라인 강좌를 제공합니다.

© 2019 Coursera Inc. All rights reserved.

앱스토어에서 다운로드하기

구글 플레이에서 받기