application assignment

Job ID: 36107993

Budget: $15 – $25 USD

So i have information that needs to be used to create a chart then a graph.
This is the information:
Hypothesis: Economic downturn
Unemployment rate increase over the past year: 2.5%
A decline in GDP growth rate over the past few quarters: -1.2%
Number of news articles reporting on economic downturn: 20
Hypothesis: Poor spending habits
Percentage of income spent on non-essential items: 30%
Number of overspending categories revealed by expense tracking software: 5
Number of friends or family members surveyed with knowledge of spending habits: 10
Hypothesis: Skills mismatch
Number of job postings reviewed with skills/experience requirements not possessed: 20
Number of job applications rejected due to skills mismatch: 8
Number of skills/certifications identified as necessary for the desired job: 3
Hypothesis: Increased utility bills
Average monthly utility bill over past 6 months: $150
Increase in energy usage over the past year, according to smart meter data: 12%
Percentage difference between individual's utility bill and area average: 15%


and need it to look similar to this graph layout in the attachments
Related categories: Excel Charts