School of Computing and Information Sciences
Computer Business Applications Instructor: Greg Shaw
CGS 2100
Charts with Multiple Data Series
• Consider the workbook Vega.xlsx, which shows annual sales for each of the 4 models of telescopes for each of the 3 sales regions, along with the “grand totals” for all models and for all regions combined.
• As an example of a chart with multiple data series, we could show one series for each region, grouped by telescope model, or one series for each telescope model, grouped by region. Either way, there would be 12 data points shown - one for each telescope model in each region
• To create a chart with multiple data series, simply select multiple rows and columns, including the rows and column headings
• When the data series are in the columns
o there is one data series for each spreadsheet column
o the column labels appear in the legend
o the row labels are used as the category axis labels
• When the data series are in the rows
o there is one data series for each spreadsheet row
o the row labels appear in the legend
o the column labels are used as the category axis labels
← To switch the data series between the rows and the columns:
Chart Tools | Design | Data | Switch Row/Column
When selecting rows and columns for charts with multiple data series, NEVER select the row with the column totals or the column with the row totals. By definition, these “grand total” data points will be as big as all the other data points combined, effectively obscuring the message you are trying to send!
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- introduction to microcomputers
- step by step 1 select data to include in a chart
- school of computing and information sciences
- lab 1 hints and practice for using excel
- furman university
- how to make a line graph with multiple lines
- epi info 7 user guide chapter 8 visual dashboard
- school of computing and information sciences creating
Related searches
- finance and information technology
- ministry of education youth and information jamaica
- computer and information systems managers
- business management and information systems
- computer and information technology pdf
- statistics and information technology
- natural and applied sciences define
- berkeley school of information tenure track opening
- speech and hearing sciences ecu
- speech and hearing sciences jobs
- speech and hearing sciences graduate
- berkeley school of information ranking