New to using excels charts

Flyers1974

New Member
Joined
Feb 11, 2017
Messages
3
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?
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Smitty

MrExcel MVP
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Feb 11, 2017
Messages
3
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.
HTML:
[[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

MrExcel MVP
Joined
May 14, 2003
Messages
4,755
Office Version
365
Platform
Windows, MacOS
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

New Member
Joined
Feb 11, 2017
Messages
3
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

MrExcel MVP
Joined
May 14, 2003
Messages
4,755
Office Version
365
Platform
Windows, MacOS
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.

 

Forum statistics

Threads
1,089,272
Messages
5,407,316
Members
403,133
Latest member
Whatsit6743

This Week's Hot Topics

Top