Data Visualization in Excel: All Excel Charts and Graphs [Video]
-
Free ChapterIntroduction and basics
-
Most important Charts and Best practices
- Bar and column charts
- Formatting charts
- Best Practices: Bar Chart
- Line Charts
- Avoiding the Spaghetti plot
- Area Charts
- Pie and Doughnut Charts
- Why we should avoid Pie charts!
- Scatter plot or XY chart
- Frequency Distribution and Histograms
- Waterfall charts
- Hierarchy Charts: Sunburst and Treemap
- Combination charts
- Highlighting chart message
- Eliminating Distractions from the Graph
- Avoiding clutter
-
Pivot charts
-
Less used charts
-
Sparklines
-
Infographics using Excel charts
Excel charts enable spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, you can easily create different types of charts to display data graphically.
While most courses only cover how to draw different types of charts in Excel, this course is carefully designed to help you learn the most used chart types in the business environment, including new types such as sunburst, treemap, and waterfall charts. With this course, not only will you become familiar with the elements of charts but also be able to implement them in your work with the help of relevant business examples. Once you have grasped the charting tools, you’ll also learn how to highlight your message and avoid clutter so that your message is conveyed clearly.
By the end of this course, you’ll be equipped with the skills to create impressive charts that express the value of numbers and make it easier to understand trends and comparisons.
All code and supporting files are available at-
https://github.com/sanjanapackt/PacktPublishing-Data-Visualization-in-Excel-All-Excel-Charts-and-Graphs
- Publication date:
- February 2020
- Publisher
- Packt
- Duration
- 3 hours 54 minutes
- ISBN
- 9781800206441