Non-contiguous rows and columns can be selected by pressing and holding the Ctrl key while selecting each data series. Columns or rows containing totals should not be selected in most cases. To select the cells to chart, click and drag the cursor from the top left cell to the bottom right cell of your range, including column and row headings. Non-adjacent rows or columns can be selected, but they must form a rectangle. In the worksheet below, we have outlined three data series which form a cell range. Most other chart types can handle multiple data series. If multiple data series are selected, Excel will ignore all but the first. A data series is a row or column of numbers that are entered into the worksheet for graphing.Ī pie chart can only chart a single data series. When you chart in Excel, you chart one or more data series. This chart is most useful displaying trends over time or other ordered category for single or multiple data series.įor detailed descriptions of all chart types available in Excel, and links to individual tutorials, see Excel Chart Types: Pie, Column, Line, Bar, Area, and Scatter Charts. Though useful for single or multiple series, this chart type especially effective in comparing large quantity of values in a single series.ĭisplays values as equally spaced points connected with a line. The 3-D Column chart displays multiple series over three axes (X, Y, and Z).ĭisplays values for one or more series using horizontal columns. Using vertical columns, displays values for one or more series over time or other category.Įspecially effective in comparing values for multiple series. Typeĭisplays the percentages of a whole for each member in a series.Įxcellent chart for comparing values in a single series as percentages of a whole. The type of data often determines the chart type. Choosing the Chart Typeīefore selecting the data you wish to graph, it's helpful to have an idea of what chart type would best display your data. For related tutorials, see our Chart & Graph Information Center. We'll begin by briefly looking at the most popular types of charts available in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |