How to Make Charts in Excel and Examples

excelcartstutorial.blogspot.com - The Charts command group is a collection of command buttons used for creating charts in Excel. This command provides 15 types of graphs that can be created to represent data visually. As the saying goes, "A Picture Speaks a Thousand Words", it is easier for us to convey the results of data analysis accompanied by graphs as support.

A. Types of Microsoft Excel Charts

The following are pictures of 15 types of charts that can be made with Microsoft Excel.

Types of Charts in Microsoft Excel
ColumnLinePieBarArea
ColumnLinePieBarArea
ScatterStockSurfaceRadarTreemap
XYStockSurfaceRadarTreemap
SunburstHistogramBox & WhiskerWaterfallCombo
SunburstHistogramBoxWaterfallCombo

B. Charts Command Group (Chart)

The Charts command button is on the Insert ribbon menu , here is an illustration

the charts command group

To create a chart, you can drag the range that will be used as a table. You can also format the range into an Excel table. So when creating the chart you don't have to drag it, just highlight one of the cells in the Excel table.

C. How to Make Charts in Excel

Column type graphs are one type of graph that is often used to represent data. Column charts in Excel are also called bar charts.

Here are some of the most suitable cases of using this chart,

  1. Sales graph based on the type of goods of a company in a month.
  2. Graph of the average height based on the gender of a kindergarten.
  3. Graph of the voting results of a general election.

Any chart created in Microsoft Excel can be converted to any other available chart type, for example a column chart (bar) can be converted to a line chart. This is tailored to the needs of the analysis and representation of the data required.

Example:

In the following example, a column graph is made from the production data of a paper company as follows,

Production Table

Here are the steps on how to make a chart in Excel

  1. Block range of data
  2. Click the Insert ribbon select Recommended Carts , so the Insert Cart window opens

    Charts

    Tip: Once you get used to it you can create charts using the command buttons located to the right of the Recommended Charts button .

  3. Select the All Charts Tab , then click Column
  4. Select the Column type to be used, then click OK
  5. Shift the created chart

    Choose the type of Excel charts

  6. Add the name of the graphic by clicking on the word Cart Title

    Production Table

  7. Perform Manual Chart Formatting

    Formatting Charts is a process related to customizing the created charts. You can bring up the Format Selection by double-clicking the table area . So that the Format Charts panel will appear based on the design element selected in the table (for example, line chart elements, chart titles, etc.). Format Charts consists of 3 types of tab commands,

    Format Charts

    • Fill & Line: to customize the color and outline of the selected element
    • Effects: to provide a visual effect on the selected element
    • Size Properties: to change the size of the selected element
    Perform Manual Formatting of Charts
    Perform Manual Formatting of Charts
  8. At this point you have succeeded in making a chart

D. Chart Designing and Formatting with the Ribbon Chart Tools

The Chart Tools Ribbon is the ribbon that appears when you highlight a chart. The following is an illustration based on the example above,

Ribbon Charts Tools

This Ribbon consists of 2 tabs, namely Design and Format ,

D1. Using the Design Tab

The design tab is a tab related to the customization of the graphic that is made. The Location of the Design tab is shown in the image above, next to the Format Tab. There are 5 groups of commands on the design tab.

  1. Chart Layout: Adding Graphic Elements

    The Chart Layout command group is used to add / remove elements on the chart, namely axes , axes titles , charts ( chart titles ), labels ( data labels ), data tables ( data tables ), error bars , line charts. ( gridlines ), legend / caption ( legend ), lines , trendlines , up / down bars . There are 2 commands, namely Add Chart Element (add manual elements) and Quick Layout (quickly add elements with a template that is already available).

    Using a Chart Layout

  2. Chart Style: Change the Chart Style

    The Chart Style command group is used to select styles on the chart. You can change the style as well as the style color (Change Colors) on the chart using this group of commands.

    Change the Excel Chart Style

  3. Data: Select Graph Data

    The data command group is a group of commands used to select data to be displayed on the chart. This command group consists of 2 command buttons, namely Switch Row / Column and Select Data .

    The Row / Column switch is a command button that is used to change the chart grouping by column or row. For example, grouping data based on rows consists of notebooks, pocket books, folios, and drawing books. With each group having 2 data points, namely production and demand. Vice versa which can be illustrated in the following figure,

    Data Switch

    Select Data is a command button to select table rows and columns that will be used as data on the created chart.

    Select Data
    An example of removing the "Request" data points on the chart

    You can increase or decrease the data displayed on the graph by checking or unchecking the Select Data Source window as illustrated above.

  4. Type / Change Cart Type: Selects a Chart Type

    This command button is used to change the type of chart that is highlighted. When this command is clicked, the Change Cart Type window will open (as in section B of this article)

    Change chart type

  5. Location / Move Cart: Move Chart

    This command is used to move the highlighted sheet to another sheet or a new sheet. Here's the illustration,

    Move chart

    In the Move Chart window, you can select the column New sheet (move to a new special sheet) and Object in (move to an existing sheet). bandarq online

D2. Using the Format Tab

Tab format is a tab that contains a set of commands related to formatting charts that have been made. In Part B , we learned how to manually format using Format Selection . Using the Format tab is a more complex way of formatting graphics.

Ribbon format

There are 6 groups of commands as follows,

  1. Current Selection : formats the chart based on the highlighted elements via the Format Selection Pane.
  2. Insert Shape : to add a shape object to the created graphic.
  3. Shape Style : to change the style of the highlighted shape.
  4. WordArt Style : to add a WordArt effect  to the text in graphics .
  5. Arrange : to adjust the position of objects and graphics.
  6. Size : to change the size of the highlighted graphic.

E. Quick Access Feature on Charts

In Microsoft Excel 2013 and 2016 there are 3 additional Quick Access features on the chart as follows,

  1. Chart Elements: Shortcuts to Adding Graphic Elements

    Element Charts Shortcuts

  2. Cart Styles: Shortcut Chart Style

    Chart Style shortcuts

  3. Chart Filters: Shortcuts to Selecting Data

    Chart Filters

read : 7-line-charts-and-how-to-make-line

Komentar

Posting Komentar

Postingan populer dari blog ini

7 Line Charts and How to Make a Line Graph in Excel

Gambar
excelcartstutorial.blogspot.com  -  A line graph or line is a graph that uses points as data points and is then connected to the next point.  This graph is one of the most used graphs after bar charts.  Creating a line chart in Excel is not much different from  how to make a bar chart  .  In general, line graphs are used to compare data based on a certain time series;  for example: website traffic per minute, number of tourists per day, number of babies born each month, and so on. A. Types of Line or Line Charts in Excel Here are 7 types of line chart templates in Microsoft Excel that you can choose from quickly. 7 Types of Excel Line Chart Templates 1) Standard Line 2) Stacked 3) 100% Stacked 4) Line with Markers 5) 100% Stacked +   Markers 6) Stacked +  Markers 7) 3-D Line B. How to Make a Line Chart in Excel For example, a line graph will be drawn from the birth data of babies in a hospital based on sex for 1 year as follows, Block range of data Click the Insert Line and Area Chart
Baca selengkapnya

How to Make an Excel Pie Cart or Pie Cart Chart

Gambar
excelcartstutorial.blogspot.com -  Pie chart or pie chart is a form of data visualization in a circle divided into slices that represent the numerical value of a data.  Pie charts are often used to represent data with a single numeric variable.  Here's how to make an Excel pie chart. There are 5 types of pie charts in Microsoft Excel Pie Chart Types Pie 3-D Pie Pie of Pie Bar of Pie Doughnout A. How to Make a Pie Chart in Excel (Pie) To make a pie chart the method is not much different from making a bar chart in the previous tutorial.  The following is an example of a pie chart application made with Microsoft Excel, Example: Making a Pie Chart for the Population of Southeast Asia A pie chart will be made from the population data of the population of Southeast Asia in 2017 based on the statistical calculations of the United Nations Population Division as follows, Here are the steps for making an Excel pie chart, Highlight the data range Click the Insert Pie and Donut Chart command
Baca selengkapnya