Histograms

[Jim]

Can we make histograms with conditions? For example
Counts in column 4 based on col 1 = x & col 2 = y & col 3
= z.
I know we can use the conditional sum wizard to find a
single total based on multiple conditions, but can we
iterate through to create mulptiple answers?
Example we have a building with 10 floors 4 different
cores and 6 door types.
Data in columns--- door floor core doortype
1 3 3 5
2 2 2 1
3 5 4 4
How to make a table of the types of doors for each floor
or each core or coor 1 and floor 2 etc?

 

[Debra Dalgleish]

You can create a pivot table from the list, to get a flexible summary of
the data, then create a PivotChart from that:
1. Select a cell in the list
2. Choose Data>PivotTable Report
3. Click Next, select the cells with data, click Next
4. Click Layout
5. Drag the Floor and Core buttons to the row area
6. Drag the Door button to the Data area,
where it will become Sum of Door
7. Double-click on the Sum of Door button, and choose to
summarize by Count, click OK
8. Click Next, choose a location for the Pivot Table, click Finish
9. Then, create a PivotChart from the PivotTable.

To see variations on the summary, add or remove fields from the Row area.

 

[Jim]

Thanks very much!

-----Original Message-----
You can create a pivot table from the list, to get a flexible summary of
the data, then create a PivotChart from that:
1. Select a cell in the list
2. Choose Data>PivotTable Report
3. Click Next, select the cells with data, click Next
4. Click Layout
5. Drag the Floor and Core buttons to the row area
6. Drag the Door button to the Data area,
where it will become Sum of Door
7. Double-click on the Sum of Door button, and choose to
summarize by Count, click OK
8. Click Next, choose a location for the Pivot Table, click Finish
9. Then, create a PivotChart from the PivotTable.

To see variations on the summary, add or remove fields from the Row area.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.