Agb 260 agribusiness information technology
1 / 28

AGB 260: Agribusiness Information Technology - PowerPoint PPT Presentation

  • Uploaded on

AGB 260: Agribusiness Information Technology. Graphing and Sparklines. Useful Chapters in the Textbook Regarding this Lecture. Chapter 44 Chapter 49 Chapter 50 Chapter 51 Chapter 52 Throughout other chapters. Charts in Excel. A chart is a visual representation of data.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about ' AGB 260: Agribusiness Information Technology' - tuwa

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Useful chapters in the textbook regarding this lecture
Useful Chapters in the Textbook Regarding this Lecture

  • Chapter 44

  • Chapter 49

  • Chapter 50

  • Chapter 51

  • Chapter 52

  • Throughout other chapters.

Charts in excel
Charts in Excel

  • A chart is a visual representation of data.

  • If done correctly, it allows you to present information in a visual form that is usually more understandable.

  • Charts in Excel are embedded and reside on the object layer.

    • A chart can also be put into a chart sheet.

Types of charts in excel
Types of Charts In Excel

  • Column

  • Bar

  • Line

  • Pie

  • Scatter (XY)

  • Area

  • Radar

  • Surface

  • Bubble

  • Stocks

Column chart
Column Chart

  • A column chart presents your data in vertical columns.

  • These charts are used to compare discrete items where the height corresponds to the value.

  • Column charts come in:

    • Clustered Column (3D optional)

    • Stacked Column (3D optional)

    • 100% Stacked Column (3D optional)

    • 3D Column

Bar chart
Bar Chart

  • A bar chart is a column chart that has been flipped 90 degrees.

  • You may want to use a bar chart over a column chart to make your category labels easier to display and read.

  • Types of column chart:

    • Clustered Bar (3D optional)

    • Stacked Bar (3D optional)

    • 100% Stacked Bar (3D optional)

Line charts
Line Charts

  • These charts are meant to plot data that is relatively continuous, e.g., years.

  • Line charts can help you understand the trends and seasonality of your data.

  • Types of Line Charts:

    • Line (Optional with Markers)

    • Stacked Line (Optional with Markers)

    • 100% Stacked Line (Optional with Markers)

    • 3D Line

Line charts continued
Line Charts Continued

  • You can add trend lines to your line charts.

  • This trends can be linear or non-linear.

  • You can information regarding the trend line, including:

    • The equation that makes the trend line

    • R2

Pie charts
Pie Charts

  • A pie chart is helpful in visualizing proportional data or data that can be made proportional.

  • A pie chart can only handle one data series.

  • You should be cautious on the number of items you represent in a pie chart.

  • Types of Pie Charts:

    • Pie (3D optional)

    • Pie of Pie

    • Bar of Pie

    • Doughnut

Scatter xy chart
Scatter (XY) Chart

  • A scatter chart shows the relationship between two or more variables where one of the variables could be considered independent variable to the other.

  • Types of Scatter Charts:

    • Scatter

    • Scatter with Smooth Lines and Markers

    • Scatter with Smooth Lines

    • Scatter with Straight Lines and Markers

    • Scatter with Straight Lines and Markers

Area charts
Area Charts

  • Area Charts are good at displaying how each contributes to the whole.

  • Types of Area Charts:

    • Area (3D Optional)

    • Stacked Area (3D Optional)

    • 100% Stacked Area (3D Optional)

Bubble chart
Bubble Chart

  • A Bubble Chart is much like a scatter chart in the sense that it allows you to see the relationship between two variables, but it goes one step further by allowing you the ability to see a third dimension to the data in two dimensional space.

  • Types of Bubble Charts:

Radar charts
Radar Charts

  • Radar Charts have an axis for each category where the axis moves outward as the numbers increase.

  • These charts are useful when examining seasonality of products.

  • Types of Radar Charts:

    • Radar

    • Radar with Markers

    • Filled Radar

Surface charts
Surface Charts

  • These charts display two or more variables on a surface.

  • Excel uses color to help distinguish values.

  • Types of Surface Charts:

    • 3D Surface

    • Wireframe 3D Surface

    • Contour

    • Wireframe Contour

Stock charts
Stock Charts

  • Stock Charts are displaying information that has highs, lows, and averages much like you would see with stock market data and commodity data.

  • Types of Stock Charts:

    • High-Low-Close

    • Open-High-Low-Close

    • Volume-High-Low-Close

    • Volume-Open-High-Low-Close

Sparkline graphics
Sparkline Graphics

  • A Sparkline Graphic is a chart that is placed in a single cell.

  • It allows for a quick examination for trends and variation in the data.

  • It can only deal with one series of data at a time and is placed within the cell rather than on the objects layer.

  • Types of Sparkline Graphics:

    • Line

    • Column

    • Win/Loss

Notes on charts
Notes on Charts

  • If you are unsure of what chart would be appropriate to use for your data, you can click on the Recommended Charts button on the Insert Ribbon.

    • This gives you the ability to look at your data in different types of charts that Excel believes fits your data the best.

  • The best way to learn about charts is to experiment with them.