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

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 Line2) Stacked
1 Line2 Stacked Line
3) 100% Stacked4) Line with Markers
3 100% Stacked Line4 Line with Markers
5) 100% Stacked +  Markers6) Stacked + Markers
4 Line with Markers5 Stacked Line with Markers
7) 3-D Line
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,

Line chart

  1. Block range of data
  2. Click the Insert Line and Area Chart command button on the Insert ribbon

  3. Select the required line chart type, in general there are 2-D Line and 3-D Line charts as shown in the following illustration

    Choose a chart

  4. Create a chart name by clicking "Chart Title"

    Adding the Line Graph Name

  5. Select data using the Select Data feature: Right click the graph and select Select Data

    Select the line chart data

    The Select Data feature is used to select the data entered in the graph that is created. Here are some commands you need to know in the Select Data Source window in the illustration above, bandarq online

    • Row / Column Switch: to swap the position of column and row data in the table in the created chart.
    • Check data: to select specific data that is displayed on the graph that is created.
  6. Set the chart layout

    Of course, we need to adjust the layout regarding the size and position of the graphic so that the document to be printed or presentation looks tidier. Here's the illustration,

    Set the line chart layout

  7. Related tutorial: Doing Graphic Designing and Formatting (Parts C and D)

    You can change the color, style / theme, add elements, visualize elements by designing and formatting line charts.

Read : how-to-make-excel-pie-cart-or-pie-cart

Komentar

Posting Komentar

Postingan populer dari blog ini

How to Make Charts in Excel and Examples

Gambar
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 Column Line Pie Bar Area Scatter Stock Surface Radar Treemap Sunburst Histogram Box & Whisker Waterfall Combo B. Charts Command Group (Chart) The Charts command button is on the  Insert  ribbon menu  , here is an illustration 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 tab
Baca selengkapnya