To create a chart, you need to select at least one cell in a range of data (a set of cells). Do one of the following: Show
Tip: If you don't want to include specific rows or columns of data in a chart, you can simply hide them on the worksheet, or you can apply chart filters to show the data points you want after you create the chart. Arrange data for chartsExcel can recommend charts for you. The charts it suggests depend on how you’ve arranged the data in your worksheet. You also may have your own charts in mind. Either way, this table lists the best ways to arrange your data for a given chart.
See AlsoCreate a chart Available chart types Add a data series to your chart Add or remove a secondary axis in a chart in Excel Change the data series in a chart To create a chart in Excel for the web, you need to select at least one cell in a range of data (a set of cells). Your chart will include all data in that range. Arrange data for chartsThis table lists the best ways to arrange your data for a given chart.
For more information about any of these charts, see Available chart types. What charts represent data as parts of a whole?Fractions represent equal parts of a whole or a collection.
What are the sets of related data in a chart?Series are sets of related data. A chart can have one or more series. Each chart type displays series differently.
What type of graph is used for data?If you have nominal data, use bar charts or histograms if your data is discrete, or line/ area charts if it is continuous. If you want to show the relationship between values in your dataset, use a scatter plot, bubble chart, or line charts.
Which types of graphs are used to show parts of an entire set of data?A pie graph (sometimes called a pie chart) is used to show how an overall total is divided into parts. A circle represents a group as a whole.
|