Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    How To Make

    Uploaded by

    Death Bringer
    The document provides instructions for creating different types of charts and graphs in Excel and by hand: 1) It explains how to make a pie chart, bar graph, dot plot, stem and leaf plot, histogram, and time series plot in Excel through selecting data and inserting the appropriate chart type. 2) It also provides handmade methods for creating pie charts, bar graphs, dot plots, stem and leaf plots, and histograms by organizing data and drawing or writing values according to the specific chart conventions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    How To Make

    Uploaded by

    Death Bringer
    16 views2 pages
    The document provides instructions for creating different types of charts and graphs in Excel and by hand: 1) It explains how to make a pie chart, bar graph, dot plot, stem and leaf plot, histogram, and time series plot in Excel through selecting data and inserting the appropriate chart type. 2) It also provides handmade methods for creating pie charts, bar graphs, dot plots, stem and leaf plots, and histograms by organizing data and drawing or writing values according to the specific chart conventions.

    Original Description:

    Make

    Original Title

    How_to_make

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for creating different types of charts and graphs in Excel and by hand: 1) It explains how to make a pie chart, bar graph, dot plot, stem and leaf plot, histogram, and time series plot in Excel through selecting data and inserting the appropriate chart type. 2) It also provides handmade methods for creating pie charts, bar graphs, dot plots, stem and leaf plots, and histograms by organizing data and drawing or writing values according to the specific chart conventions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    16 views2 pages

    How To Make

    Uploaded by

    Death Bringer
    The document provides instructions for creating different types of charts and graphs in Excel and by hand: 1) It explains how to make a pie chart, bar graph, dot plot, stem and leaf plot, histogram, and time series plot in Excel through selecting data and inserting the appropriate chart type. 2) It also provides handmade methods for creating pie charts, bar graphs, dot plots, stem and leaf plots, and histograms by organizing data and drawing or writing values according to the specific chart conventions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    How to make a pie chart in Excel

    1. Once your data is formatted, making a pie chart only takes a couple clicks. First, highlight the
    data you want in the chart:
    2. Then click to the Insert tab on the Ribbon. In the Charts group, click Insert Pie or
    Doughnut Chart:
    3. In the resulting menu, click 2D Pie:
    4. Once you've clicked that, your pie chart will appear!
    Handmade
    1. Organize your data.
    2. Draw a circle.
    3. Divide the circle into appropriate chunks according to your data values.
    4. You just got yourself a pie chart.

    How to make a bar graph in word


    1. Open the Microsoft Word program. You can also double-click an existing Word document to
    open it in Word.
    2. Click the "Blank document" option. Skip this step if you're opening an existing document.
    3. Click Insert.
    4. Click Chart.
    5. Click a chart layout.
    6. Click on a chart style.
    7. Click OK.
    8. Add data to your chart.
    Hand made
    1. Gather and organize your data.
    2. Make a horizontal line.
    3. Create columns and bars (the length and size depends on the amount of data).
    4. Write all the data that you want included in the bar chart.
    5. Boom! Bar graph.

    Building Excel Dot Plot Charts


    1. Select the data in columns B and C > Insert tab > Scatter Chart. It should look like this:
    2. Right-click the chart > Select Data > Edit the series name so it points to cell B71 that contains
    the year name:
    Handmade
    1. Draw grids.
    2. Count the number of data points.
    3. Draw a stack of dots that number high for each bin.
    4. And there’s your dot plot!

    Creating a Stem and leaf plot in Excel


    1. Open the Stem and Leaf Plot Template by clicking on QI Macros menu / Chart
    Templates / Stem and Leaf Plot.
    2. Input or cut and paste your data into the yellow input area.
    3. Double click on the update plot button and QI Macros will sort the data and populate
    the stems and leaves.
    Handmade
    1. Make grids, big enough for words to fit
    2. Put this in the top grids in exact order
     Your Data
     Create “Count” “ then put the count data, representing the number of data points
    with that first digit, under”
     Create “Stems” “then put the Stem data, representing the first digits of the data
    points, under it”
     Create “Median” “then put the Median data, which is the midpoint in the data set
    and is shown next to the leaf, under”
    3. And there you have a perfectly healthy Stem and Leaf plot!

    Histograms in Excel
    1. Click the Insert tab.
    2. And then click the Add a Chart icon from the ribbon's Illustrations group.
    3. Select Columns and then click the Stacked Column icon.
    4. Click OK.
    5. Fill out all the necessary data
    6. And that’s a Histogram
    Handmade
    1. Organize your data
    2. Create multiple horizontal lines and label them
    3. Create columns and bars (the length and size depends on the amount of data).
    4. Write all the data that you want included in the histogram. But
    Histogram presents numerical data whereas bar graph shows categorical data.

    Time series plot n Excel


    1. To create a time series plot in Excel, first select the time (Date and Time in this case) Column.
    2. Then the data series (stream flow in this case) column.
    3. Next, click on the Insert ribbon, and then select Scatter.
    4. From scatter plot options, select Scatter with Smooth Lines as shown.
    5. The legend, title and axes of this plot can then be reformatted to make the time series plot look a little
    more legible and professional.

    You might also like