Brother International PDP350CJ Owner's Manual - English - Page 193

Do not use numbers for the chart title, series names, or category names. For example, instead of naming categories 1, 2, and 3, use something like Day 1, Day 2 and Day 3. If you must use a number, like 1993 and 1994, place a quote mark (') before the number so Spreadsheet interprets it as text. Chart Title. The title of the chart. This label is optional. If you do not place any text in this cell, the chart will not be titled. You can title it later using the Titles and Legends choice on the Chart menu. Series Name. The series names are the labels of the spreadsheet columns. Category Name. The category names are the labels of the spreadsheet rows. Value. The numeric data values Spreadsheet charts. Each category you wish to chart should have at least one value for each series. Empty cells in your spreadsheet will be interpreted as zeros in your chart. Types of Charts All but the High/Low chart offer variations you can choose once you have created the chart. Each of the seven standard charts is illustrated in the following sections. Spreadsheet lets you create the following types of charts: S Column S Bar S Line S Area S X-Y Plot S Pie S High/Low Column chart A column chart (or a vertical bar chart) plots each category in a series as a vertical bar. The height of the bar corresponds to the value of that category. The illustration at the left shows a typical column chart. Use bar charts for comparing amounts for fixed time intervals. Variations on the standard column chart include the following: S Overlapped. The columns within each category overlap each other slightly. S Stacked. The columns within each category are stacked vertically on top of each other. The height of the stacked column is the sum of the values in the category. S Stacked Percentage. The columns in each category are stacked so that the total height represents 100%. The height of each value is shown as that value's percentage of the whole category. This is like a vertical pie chart. S One Tone With Values. Columns all have the same tone and are labeled with their numeric values. S One Tone With No Space Between Categories. Columns all have the same tone, and the last column in category 1 touches the first column in category 2 with no space between them. Spreadsheet 179