• Blog
  • Excel Downloads
    • Audit Tickmark Toolbar
  • Courses
  • Contact
  • Checkout

Excel Zoom

...because it's more than just a calculator


Using Charts in Excel

February 10, 2009 by Mark 2 Comments

There are several different types of charts found in Excel. All of which are used to display information in a way that makes it easier to interpret data.

  • Column charts are best suited to compare distinct object levels in a vertical format.
  • Line charts compare trends over even time periods, but are not necessarily used to show totals.
  • Pie charts show the relative size of a particular data point as a part of the whole.
  • Bar charts are best for comparing distinct object levels ina horizontal format. It is similar to a column chart, just flipped on its side.
  • Area charts show how individual volume changes over time in relation to a toal volume.
  • Scatter charts compare trends over uneven time or measurement intervals. This type of chart is useful to spot trends in a set of data.

Filed Under: Tips Tagged With: Charts, Tips

Looking For More Help?

Contact us with any specific questions or feedback. We love to hear from you!

Want to level up your career? See our amazing Certificated Excel Courses and be the office Hero with your new found knowledge!

Looking for the Excel Audit Tickmark Toolbar? click here, NOW ONLY $25!

Subscribe to our mailing list
  • Facebook
  • Twitter

Search this site…

Categories

  • Macros (34)
  • Tips (67)
  • Uncategorized (23)



Copyright © 2023 · Magazine Pro Theme on Genesis Framework · WordPress · Log in

Login Form

Lost your password?