| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
charting totals
I have the following data and would like to chart total number by dept. that took at least one training class, at least two etc. not sure how to chart with data like this????? ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA Total At Least 3," 2 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA Total At Least One 5 CBD MANAGERS At Least 2 1 CBD MANAGERS Total At Least 2 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS Total At Least 3," 3 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS Total At Least One 5 Thanks, Barb |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
charting totals
One option would be to set your data up like this (I've added the cell
references in which to add your titles and data to the left of each item i.e. cell A2, cell B2, etc.): (C1) Classes (A2) At Least 1 (B2) Academia (C2) 5 (B3) Managers (C3) 5 (A4) At Least 2 (B4) Academia (C4) 1 (B5) Managers (C5) 1 (A6) At Least 3 (B6) Academia (C6) 2 (B7) Managers (C7) 3 Once you have the data entered into the spreadsheet, go to the Chart Wizard. In Step 1 of the Wizard, select the Clustered Column as the chart type. Hit the Next button. In Step 2 of the chart wizard, select the range A1:C7. In the Series reference, make sure that the "in columns" option is selected. At this point you can finish the Wizard and your chart should be complete. -- John Mansfield http://cellmatrix.net "babs" wrote: I have the following data and would like to chart total number by dept. that took at least one training class, at least two etc. not sure how to chart with data like this????? ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA Total At Least 3," 2 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA Total At Least One 5 CBD MANAGERS At Least 2 1 CBD MANAGERS Total At Least 2 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS Total At Least 3," 3 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS Total At Least One 5 Thanks, Barb |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
charting totals
I see what you have set up but wondering based on my original way the data is
set up from the first post that I can quickly get it like you have it below - to get it like that I have to hand count and copy paste info. Any quick way to organize the data from the original post (possibly using a pivot table) to get it to look like below- I only gave you an example of some of the data and have a lot more than I showed. Any ideas- and thanks for helping, Barb "John Mansfield" wrote: One option would be to set your data up like this (I've added the cell references in which to add your titles and data to the left of each item i.e. cell A2, cell B2, etc.): (C1) Classes (A2) At Least 1 (B2) Academia (C2) 5 (B3) Managers (C3) 5 (A4) At Least 2 (B4) Academia (C4) 1 (B5) Managers (C5) 1 (A6) At Least 3 (B6) Academia (C6) 2 (B7) Managers (C7) 3 Once you have the data entered into the spreadsheet, go to the Chart Wizard. In Step 1 of the Wizard, select the Clustered Column as the chart type. Hit the Next button. In Step 2 of the chart wizard, select the range A1:C7. In the Series reference, make sure that the "in columns" option is selected. At this point you can finish the Wizard and your chart should be complete. -- John Mansfield http://cellmatrix.net "babs" wrote: I have the following data and would like to chart total number by dept. that took at least one training class, at least two etc. not sure how to chart with data like this????? ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA At Least 3," 1 ACADEMIA Total At Least 3," 2 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA At Least One 1 ACADEMIA Total At Least One 5 CBD MANAGERS At Least 2 1 CBD MANAGERS Total At Least 2 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS At Least 3," 1 CBD MANAGERS Total At Least 3," 3 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS At Least One 1 CBD MANAGERS Total At Least One 5 Thanks, Barb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| showing the totals in a chart/table without charting them | Excel Worksheet Functions | |||
| Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
| Charting: Displaying cumulative totals at top of stacked columns | Charts and Charting in Excel | |||
| Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
| Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions | |||
Hybrid Mode
