I’ve been asked to create a stacked bar chart to show salary ranges for 3 job titles compared with the same job titles at 2 other companies.
CSR = $14 – $22 at company 1
CSR = $16 – $22 at company 2
CSR = $10 – $16 at company 3
CSRLead = $18 – $22 at company 1
(no other companies have this position, but I need to show it for company 1)
CA = $23 – $26 at company 1
CA = $23 – $26 at company 2
CA = $18 – $22 at company 3
The requestor wants the companies as the X axis
Job tiles show once for each company (as a range)
Salary shows as the Y axis in $2 increments
I have no idea how to do even set up the data source so it will display the data as a range, not show each job title separately.
Can you tell me how to set this up, please?
