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?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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.
 
Upvote 0
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]
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.

oLQkkEl.png


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.

KkTrOkJ.png
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top