Charts and graphs for microsoft office

This vast collection of charts has all the communication and tracking tools you need for work, school, home, and play. Find a flowchart in a variety of styles, colors, and time periods to set a schedule and mark milestones on a project of any size. A flow chart can include different details, such as task ownership and start and end date, and different functions, such as auto updates. For processes involving multiple teams, a cross-functional flowchart is a jargon-free way to describe complex actions and define responsibilities.

This collection also includes a classic Gantt chart in a variety of layouts, and other Excel chart templates that are ready to edit. Chart templates for more personal use include retirement planning charts, diet and exercise logs, event timelines, family tree charts, travel itineraries, seating charts, even a tournament bracket.

Explore chart templates to find what works for you. Explore premium templates Bring your ideas to life with more customizable templates and new creative options when you subscribe to Microsoft Milestone infographic timeline. Agile Gantt chart. Retirement planner. Explore premium templates. The treemap chart can be plotted when empty blank cells exist within the hierarchal structure and treemap charts are good for comparing proportions within the hierarchy.

Note: There are no chart sub-types for treemap charts. The sunburst chart is ideal for displaying hierarchical data and can be plotted when empty blank cells exist within the hierarchal structure. Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy.

A sunburst chart without any hierarchical data one level of categories , looks similar to a doughnut chart. However, a sunburst chart with multiple levels of categories shows how the outer rings relate to the inner rings. The sunburst chart is most effective at showing how one ring is broken into its contributing pieces. Note: There are no chart sub-types for sunburst charts. Data plotted in a histogram chart shows the frequencies within a distribution.

Each column of the chart is called a bin, which can be changed to further analyze your data. Histogram The histogram chart shows the distribution of your data grouped into frequency bins. Pareto chart A pareto is a sorted histogram chart that contains both columns sorted in descending order and a line representing the cumulative total percentage. A box and whisker chart shows distribution of data into quartiles, highlighting the mean and outliers.

These lines indicate variability outside the upper and lower quartiles, and any point outside those lines or whiskers is considered an outlier. Use this chart type when there are multiple data sets which relate to each other in some way. Note: There are no chart sub-types for box and whisker charts. A waterfall chart shows a running total of your financial data as values are added or subtracted. It's useful for understanding how an initial value is affected by a series of positive and negative values.

The columns are color coded so you can quickly tell positive from negative numbers. Note: There are no chart sub-types for waterfall charts. Typically, the values decrease gradually, allowing the bars to resemble a funnel. Read more about funnel charts here. Data that's arranged in columns and rows can be plotted in a combo chart. Combo charts combine two or more chart types to make the data easy to understand, especially when the data is widely varied.

Shown with a secondary axis, this chart is even easier to read. In this example, we used a column chart to show the number of homes sold between January and June and then used a line chart to make it easier for readers to quickly identify the average sales price by month. Clustered column — line and clustered column — line on secondary axis With or without a secondary axis, this chart combines a clustered column and line chart, showing some data series as columns and others as lines in the same chart.

Stacked area — clustered column This chart combines a stacked area and clustered column chart, showing some data series as stacked areas and others as columns in the same chart. Custom combination This chart lets you combine the charts you want to show in the same chart. You can use a Map Chart to compare values and show categories across geographical regions.

For example, Countries by Population uses values. The values represent the total population in each country, with each portrayed using a gradient spectrum of two colors. The color for each region is dictated by where along the spectrum its value falls with respect to the others. In the following example, Countries by Category, the categories are displayed using a standard legend to show groups or affiliations.

Each data point is represented by an entirely different color. Select the chart, click the Design tab, and click Change Chart Type. Many chart types are available to help you display data in ways that are meaningful to your audience. Here are some examples of the most common chart types and how they can be used. Data that is arranged in columns or rows on an Excel sheet can be plotted in a column chart. In column charts, categories are typically organized along the horizontal axis and values along the vertical axis.

Clustered column chart Compares values across categories. A clustered column chart displays values in 2-D vertical rectangles. A clustered column in a 3-D chart displays the data by using a 3-D perspective. Stacked column chart Shows the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. A stacked column chart displays values in 2-D vertical stacked rectangles.

A 3-D stacked column chart displays the data by using a 3-D perspective. A 3-D perspective is not a true 3-D chart because a third value axis depth axis is not used. They compare data points along the horizontal and the depth axes. Data that is arranged in columns or rows on an Excel sheet can be plotted in a line chart. Line charts can display continuous data over time, set against a common scale, and are therefore ideal to show trends in data at equal intervals.

Line charts work well if your category labels are text, and represent evenly spaced values such as months, quarters, or fiscal years.

Line chart with or without markers Shows trends over time or ordered categories, especially when there are many data points and the order in which they are presented is important.

Stacked line chart with or without markers Shows the trend of the contribution of each value over time or ordered categories. If there are many categories or the values are approximate, use a stacked line chart without markers.

Data that is arranged in one column or row only on an Excel sheet can be plotted in a pie chart. The data points in a pie chart are displayed as a percentage of the whole pie. Consider using a pie chart when you have only one data series that you want to plot, none of the values that you want to plot are negative, almost none of the values that you want to plot are zero values, you don't have more than seven categories, and the categories represent parts of the whole pie.

Pie chart Displays the contribution of each value to a total in a 2-D or 3-D format. Pie of pie or bar of pie chart Displays pie charts with user-defined values that are extracted from the main pie chart and combined into a secondary pie chart or into a stacked bar chart.

These chart types are useful when you want to make small slices in the main pie chart easier to distinguish. Doughnut chart Like a pie chart, a doughnut chart shows the relationship of parts to a whole. However, it can contain more than one data series. Each ring of the doughnut chart represents a data series.

Displays data in rings, where each ring represents a data series. Clustered bar and 3-D Clustered bar chart Compares values across categories. In a clustered bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis. A clustered bar in 3-D chart displays the horizontal rectangles in 3-D format.

It does not display the data on three axes. Stacked bar and 3-D Stacked bar chart Shows the relationship of individual items to the whole. A stacked bar in 3-D chart displays the horizontal rectangles in 3-D format. Data that is arranged in columns and rows on an Excel sheet can be plotted in an xy scatter chart. A scatter chart has two value axes.

It shows one set of numeric data along the horizontal axis x-axis and another along the vertical axis y-axis. It combines these values into single data points and displays them in irregular intervals, or clusters. Scatter charts show the relationships among the numeric values in several data series, or plot two groups of numbers as one series of xy coordinates. Scatter charts are typically used for displaying and comparing numeric values, such as scientific, statistical, and engineering data. Scatter chart Compares pairs of values.

Use a scatter chart with data markers but without lines if you have many data points and connecting lines would make the data more difficult to read. You can also use this chart type when you do not have to show connectivity of the data points. Scatter chart with smooth lines and scatter chart with smooth lines and markers Displays a smooth curve that connects the data points.

Smooth lines can be displayed with or without markers. Scatter chart with straight lines and scatter chart with straight lines and markers Displays straight connecting lines between data points.

Straight lines can be displayed with or without markers. Bubble chart or bubble chart with 3-D effect A bubble chart is a kind of xy scatter chart, where the size of the bubble represents the value of a third variable. Compares sets of three values instead of two. The third value determines the size of the bubble marker. You can choose to display bubbles in 2-D format or with a 3-D effect.

Data that is arranged in columns or rows on an Excel sheet can be plotted in an area chart. By displaying the sum of the plotted values, an area chart also shows the relationship of parts to a whole. Area charts emphasize the magnitude of change over time, and can be used to draw attention to the total value across a trend. For example, data that represents profit over time can be plotted in an area chart to emphasize the total profit.

Area chart Displays the trend of values over time or other category data. Generally, consider using a line chart instead of a nonstacked area chart because data from one series can be obscured by data from another series. Stacked area chart Displays the trend of the contribution of each value over time or other category data.

A stacked area chart in 3-D is displayed in the same manner but uses a 3-D perspective. Data that is arranged in columns or rows in a specific order on an Excel sheet can be plotted in a stock chart. As its name implies, a stock chart is most frequently used to show the fluctuation of stock prices. However, this chart may also be used for scientific data. For example, you could use a stock chart to indicate the fluctuation of daily or annual temperatures.

High-Low-Close stock chart Illustrates stock prices. It requires three series of values in the correct order: high, low, and then close. Open-High-Low-Close stock chart Requires four series of values in the correct order: open, high, low, and then close. Volume-High-Low-Close stock chart Requires four series of values in the correct order: volume, high, low, and then close.

Volume-Open-High-Low-Close stock chart Requires five series of values in the correct order: volume, open, high, low, and then close. Note: If you open a presentation that was created in an earlier version of PowerPoint and the presentation contains a graph or chart that was created by using Microsoft Graph, PowerPoint maintains the look and feel of the graph or chart and lets you continue to update your graph or chart.

Table of contents. Next: Present slide shows. Try it! Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information.

Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback!