New Posts
Home / Computer 4 Beginners / How to Use Microsoft Excel Charts.

How to Use Microsoft Excel Charts.

How to Use Microsoft Excel Charts.

In this lesson, we will learn How to use Microsoft Excel Charts. Where I have discussed following topics.

excel-charts

  • Creating charts.
  • Exploring chart types.
  • Formatting charts.
  • Working with axes, titles, and other chart elements.
  • Creating incell charts with sparklines.

Creating charts.

Chart command is mostly used in Microsoft Excel. The chart is used to show data in the graphical view. Where we can analyze our data watching charts.

There are many types of chart. Like: Columns, Line, Pie, Bar, Area, Surface, Reader, Treemap, Sunburst, Histogram, Waterfall, Combo etc.

Create a list as shown in below image.

Select the list.

Creating charts

For creating a chart with shortcut key “alt+F1”.

shortcut key of creating chart

Now you notice that menu item has changed like below.

chart options

 chart layout

If you want to remove chart by deleting use delete key from the keyboard.

Creating charts

Another way to use chart command.

Insert.

 recommended charts

 recommended charts options

Select any design/style.

Ok.

 select chart style

look of chart

recommended charts view

Another way to create a chart (Create a chart on the new worksheet).

Use shortcut key “F11”.

Creating charts

 chart look

Totally new sheet

 Totally new sheet

Exploring chart types.

It is not clear that which type of chart is best for your data. So you can easily change the type of chart by doing the following:

Select the list as shown in below image.

Creating charts

Or.

 Exploring chart types 2

Or.

 Exploring chart types 3

 Exploring chart types 4

 change chart types

Formatting charts.

When you create a chart in excel you can apply formatting one it doing following steps.

Select the list as shown in below image.

Creating charts

Click on Insert Tab

Formatting charts 2

Click on Recommended Charts.

 Formatting charts 3

Click on  Design Tab.

Formatting charts 4

Press and hold the mouse on Quick Layout.

Formatting charts 5

Format Tab.

 Formatting charts 6

Working with axes, titles, and other chart elements.

First select chart.

Then go to format Tab.

 Working with axes, titles, and other chart elements

Working with axes, titles, and other chart elements 2

From Design Tab.

 Working with axes, titles, and other chart elements 3

 Working with axes, titles, and other chart elements 4

 Working with axes, titles, and other chart elements 5

Creating in cell charts with sparklines.

Sometimes you want to visual company data but you do not have room or space for the chart. You have trouble creating the chart.

Select the list as shown in below image.

 Formatting charts

 Creating in cell charts with spark lines 2

 Creating in cell charts with spark lines 3

Design Tab.

 Creating in cell charts with spark lines 4

 

 

 

 

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …