New to using excels charts

[Flyers1974]

I am new to using excel for charting. I was asked to prepare charts or tables that will effectively answer the following questions:
Of the subsectors noted in the table, which produced the highest number of fatal claims in 1990 – 2014 for:
· Pneumoconiosis (make sure to include asbestosis)
· Cardiovascular disease

Which would be the best chart for this and how would i set it up?

 

[Smitty]

Welcome to the Board!

It's hard to tell without seeing your data (if you follow the HTML Maker link in my sig, you can post a screen shot). You might want to start with a PivotTable to summarize the data, then create a column chart off of it.

 

[Flyers1974]

Welcome to the Board!

It's hard to tell without seeing your data (if you follow the HTML Maker link in my sig, you can post a screen shot). You might want to start with a PivotTable to summarize the data, then create a column chart off of it.

[[TABLE="width: 1456"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 12"]Table 29     Number of work-related deaths, by subsector and by detailed category of disease or injury; 1991-2015[/TD]
[/TR]
[TR]
[TD]Subsector Name[/TD]
[TD]Subsector #[/TD]
[TD]Asbestos[/TD]
[TD]Non Asbestos Cancer[/TD]
[TD]Silicosis[/TD]
[TD]Pneumoconiosis[/TD]
[TD]Other Exposure[/TD]
[TD]Cardiovascular[/TD]
[TD]Other Disease[/TD]
[TD]MVI[/TD]
[TD]Other injury[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Agriculture[/TD]
[TD]7010[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]15[/TD]
[TD]70[/TD]
[TD]91[/TD]
[/TR]
[TR]
[TD]Fishing[/TD]
[TD]7020[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]92[/TD]
[TD]105[/TD]
[/TR]
[TR]
[TD]Forestry[/TD]
[TD]7030[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]12[/TD]
[TD]1[/TD]
[TD]68[/TD]
[TD]303[/TD]
[TD]393[/TD]
[/TR]
[TR]
[TD]Oil, Gas & Mineral Resources[/TD]
[TD]7040[/TD]
[TD]31[/TD]
[TD]2[/TD]
[TD]47[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]19[/TD]
[TD]59[/TD]
[TD]176[/TD]
[/TR]
[TR]
[TD]Food & Beverage Products[/TD]
[TD]7110[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]11[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]Metal & Non-Metallic Mineral Products[/TD]
[TD]7120[/TD]
[TD]212[/TD]
[TD]36[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]11[/TD]
[TD]47[/TD]
[TD]323[/TD]
[/TR]
[TR]
[TD]Petroleum, Coal, Rubber, Plastic & Chemical Products[/TD]
[TD]7130[/TD]
[TD]12[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]13[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]Wood & Paper Products[/TD]
[TD]7140[/TD]
[TD]101[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]87[/TD]
[TD]221[/TD]
[/TR]
[TR]
[TD]Other Products[/TD]
[TD]7150[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]9[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]General Construction[/TD]
[TD]7210[/TD]
[TD]347[/TD]
[TD]11[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]16[/TD]
[TD]9[/TD]
[TD]64[/TD]
[TD]214[/TD]
[TD]669[/TD]
[/TR]
[TR]
[TD]Heavy Construction[/TD]
[TD]7220[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]14[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Road Construction & Maintenance[/TD]
[TD]7230[/TD]
[TD]6[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]23[/TD]
[TD]29[/TD]
[TD]62[/TD]
[/TR]
[TR]
[TD]Warehousing[/TD]
[TD]7310[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Transportation & Related Services[/TD]
[TD]7320[/TD]
[TD]66[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]11[/TD]
[TD]4[/TD]
[TD]307[/TD]
[TD]234[/TD]
[TD]627[/TD]
[/TR]
[TR]
[TD]Retail[/TD]
[TD]7410[/TD]
[TD]14[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]22[/TD]
[TD]63[/TD]
[/TR]
[TR]
[TD]Wholesale[/TD]
[TD]7420[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]12[/TD]
[TD]23[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]Public Administration[/TD]
[TD]7530[/TD]
[TD]19[/TD]
[TD]51[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]20[/TD]
[TD]0[/TD]
[TD]17[/TD]
[TD]26[/TD]
[TD]134[/TD]
[/TR]
[TR]
[TD]Accommodation, Food & Leisure Services[/TD]
[TD]7610[/TD]
[TD]9[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]19[/TD]
[TD]67[/TD]
[TD]106[/TD]
[/TR]
[TR]
[TD]Business Services[/TD]
[TD]7620[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]19[/TD]
[TD]13[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]Professional, Scientific & Technical Services[/TD]
[TD]7630[/TD]
[TD]10[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]26[/TD]
[TD]59[/TD]
[/TR]
[TR]
[TD]Other Services[/TD]
[TD]7640[/TD]
[TD]68[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]34[/TD]
[TD]74[/TD]
[TD]194[/TD]
[/TR]
[TR]
[TD]Education[/TD]
[TD]7650[/TD]
[TD]19[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]Health Care & Social Services[/TD]
[TD]7660[/TD]
[TD]16[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]16[/TD]
[TD]10[/TD]
[TD]52[/TD]
[/TR]
[TR]
[TD]Utilities[/TD]
[TD]7670[/TD]
[TD]27[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]15[/TD]
[TD]49[/TD]
[/TR]
[TR]
[TD]Self-Insured Employers[/TD]
[TD]SIE[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]No Subsector Assigned[/TD]
[TD]NSA[/TD]
[TD]59[/TD]
[TD]3[/TD]
[TD]10[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD]16[/TD]
[TD]63[/TD]
[TD]163[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Total[/TD]
[TD]1,062[/TD]
[TD]132[/TD]
[TD]76[/TD]
[TD]13[/TD]
[TD]32[/TD]
[TD]120[/TD]
[TD]45[/TD]
[TD]700[/TD]
[TD]1,539[/TD]
[TD]3,719[/TD]
[/TR]
</tbody>[/TABLE]
/HTML]

 

[Jon Peltier]

Do you want to compare all sectors but highlight the highest for each category? What I would do is make two tables from this one. Each has the sector as the first column, then one has each of the fatal claim causes as its second column. Sort by this second column, then make a bar chart. The charts will be sorted in the same way as the input data is.

 

[Flyers1974]

Yes, that is what I would like to do but I am not sure how. I have never had to use or make charts of any kind so I am not sure how to even do this.

 

[Jon Peltier]

Okay, I'll do one for you. On the left, I have copied the Subsector Name and Cardiovascular columns from the table, then sorted in descending order by the Cardiovascular column. I selected the data and inserted a bar chart.

The chart isn't perfect, so I fixed it. First, I made it a bit taller.

Then I formatted the vertical axis. Double click the axis, or select it and press Ctrl+1 (numeral one), to format it. Check the Categories in Reverse Order box, and select Horizontal Axis Crosses: At Maximum Category. Then under Labels: Interval Between Labels, I selected Specify Interval Unit, and entered 1.