agb 260 agribusiness information technology n.
Skip this Video
Loading SlideShow in 5 Seconds..
AGB 260: Agribusiness Information Technology PowerPoint Presentation
Download Presentation
AGB 260: Agribusiness Information Technology

Loading in 2 Seconds...

play fullscreen
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

Download Now 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.