Create Line Chart In Excel

This topic has been explained in great detail in the video shown below, to learn this topic just play the video and the notes are mentioned below the video.


Create Line Chart In Excel






 

Line Chart in Excel

A line chart distributes category data evenly along a horizontal (category) axis , and distributes all numerical value data along a vertical (value) axis.

Line charts can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals or over time. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. As a general rule, use a line chart if your data has non-numeric x values — for numeric x values, it is usually better to use a scatter chart.

Create a line chart

Formatted line chart

So, how did we create this line chart? The following procedure will help you create a line chart with similar results. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data.

  1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a line chart.How to copy the example worksheet data
    1. Create a blank workbook or worksheet.
    2. Select the example in the Help topic.

      NOTE: Do not select the row or column headers.

      Selecting an example from Help

      Selecting an example from Help
    3. Press CTRL+C.
    4. In the worksheet, select cell A1, and press CTRL+V.
1
2
3
4
5
6
7
8
9
10
A B C
Date Daily Rainfal l Particulat e
1/1/07 4.1 122
1/2/07 4.3 117
1/3/07 5.7 112
1/4/07 5.4 114
1/5/07 5.9 110
1/6/07 5.0 114
1/7/07 3.6 128
1/8/07 1.9 137
1/9/07 7.3 104
  1. Select the data that you want to plot in the line chart.
  2. On the Insert tab, in the Charts group, click Line.Excel Ribbon Image
  3. Click Line with Markers.
  4. Click the chart area of the chart.This displays the Chart Tools, adding the Design, Layout, and Format tabs.
  5. On the Design tab, in the Chart Styles group, click the chart style that you want to use.Chart Styles on Excel RibbonFor our line chart, we used Style 2.
  6. On the Layout tab, in the Labels group, click Chart Title, and then click Above Chart.Excel Ribbon Image
  7. Click the chart title, and then type the text that you want.For our line chart, we typed Particulate Levels in Rainfall.
  8. To reduce the size of the chart title, right-click the title, and then enter the size that you want in the Size box on the shortcut menu.For our line chart, we used 14.
  9. On the chart, click the legend, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
  10. On the Layout tab, in the Labels group, click Legend, and then click the position that you want.For our line chart, we used Show Legend at Top.
  11. To plot one of the data series along a secondary vertical axis, click the data series for Rainfall, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
  12. On the Layout tab, in the Current Selection group, click Format Selection.Current Selection group on Excel Ribbon
  13. Under Series Options, select Secondary Axis, and then click Close.
  14. On the Layout tab, in the Labels group, click Axis Titles, and then do the following:
    1. To add a primary vertical axis title, click Primary Vertical Axis Title, and then click the type of vertical axis title that you want.For our line chart, we used Rotated Title.
    2. To add a secondary vertical axis title, click Secondary Vertical Axis Title, and then click the type of vertical axis title that you want.For our line chart, we used Rotated Title.
    3. Click each title, type the text that you want, and then press ENTER.For our line chart, we typed Particulate level in the primary vertical axis title, and Daily Rainfall in the secondary vertical axis title.
  15. Click the plot area of the chart, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
  16. On the Format tab, in the Shape Styles group, click the More button Button image , and then click the effect that you want to use.For our line chart, we used the Subtle Effect – Dark 1.Shape Styles group on Excel Ribbon
  17. Click the chart area of the chart.
  18. On the Format tab, in the Shape Styles group, click the More button Button image , and then click the effect that you want to use.For our line chart, we used the Subtle Effect – Accent 3.
  19. If you want to use theme colors different from the default theme that is applied to your workbook, do the following:
    1. On the Page Layout tab, in the Themes group, click Themes.Excel Ribbon Image
    2. Under Built-in, click the theme that you want to use.

Line charts can use the following chart subtypes.

  • Line and line with markers    Displayed with markers to indicate individual data values, or without, line charts are useful to show trends over time or ordered categories, especially when there are many data points and the order in which they are presented is important. If there are many categories or the values are approximate, use a line chart without markers.Line and line with markers chart
  • Stacked line and stacked line with markers    Displayed with markers to indicate individual data values, or without, stacked line charts can be used to show the trend of the contribution of each value over time or ordered categories, but because it is not easy to see that the lines are stacked, consider using a different line chart type or a stacked area chart instead.Stacked line and stacked line with markers chart
  • 100% stacked line and 100% stacked line with markers    Displayed with markers to indicate individual data values, or without, 100% stacked line charts are useful to show the trend of the percentage each value contributes over time or ordered categories. If there are many categories or the values are approximate, use a 100% stacked line chart without markers.

    TIP: For a better presentation of this type of data, consider using a 100% stacked area chart instead.

    100% stacked line and 100% stacked line with markers chart

  • 3-D line    3-D line charts show each row or column of data as a 3-D ribbon. A 3-D line chart has horizontal, vertical, and depth axes that you can modify.3-D line chart

This information is as per a Microsoft” Excel Support Post








Our Other Services




Read Free Ebooks

myeboook.com

Myebook has 1000's of free ebooks for you. On productivity, health, online income, learning, music and many more, it's free of course!



Buy Excel Course

myelesson.org/product

Become an Excel Guru, Buy the best Excel course. Learn on your mobile, tv & laptop without internet. For COD, Call 9752003788



Create Best Looking Resume

http://www.makecv.org/

At Makecv.org you get to create a amazingly professional looking resume in just 3 steps with our intuitive resume builder!


Download Excel Crash Course


This Excel Crash Course contains the list of topics that cover the most important and used features and formula of Excel . This Excel Crash Course lists 43 major topics in Excel so that you can start using Excel like a pro in the shortest possible time.



Learn Photoshop Web Designing


You can Buy the Photoshop Course to learn Photoshop and start a career in Web Designing and Photo Editing. .



Learn HTML CSS


You can Buy the HTML CSS Course to learn HTML CSS and start a career in Web Designing and Photo Editing. .


Download Full list of Excel Shortcuts


This Excel Shortcuts Complete list is to help you become save time and use Excel like a Master level user. Excel is best used when you know the Keyboard shortcuts because the use of keyboard shortcuts in Excel helps you in completing tasks faster.

I have created a Excel Shortcuts complete list for you to use Excel better, this list has 242 excel keyboard shortcuts which means that it covers almost everything that can be done using shortcuts in Excel.




Full List of Excel Formulas

This is a complete alphabetical list of all the Formula in Excel with a description. You can learn all these formulas on www.Myelesson.org




Convert Numbers to Text in Excel

Now easily convert numbers to Text in Excel with this inbuilt sheet from myelesson.org .  Many times we need the amount in figures to be converted into words. This is a typical requirement for writing checks or any other financial reports. Microsoft Excel does not have standard function available for this requirement. Just download this sheet and then you can convert any number to text in Excel.




List of Most Commonly Asked Excel Questions in Interviews

Here is the list of most asked excel related questions in interviews.  Prepare for this excel questions and you would be able to most of the excel interviews. This list of excel questions covers excel formula, excel analysis, excel reporting, excel charts and more.





Myelesson © 2010 - 2014. All rights reserved.

Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok
Do You Want to Become a Expert in Excel ?
Buy The Full Excel Course Now
Enter Your Details & We Will Contact You
Great Choice
Thank You
Ok