Excel Graph Help

EMY245

New Member
Joined
Aug 6, 2013
Messages
20
Hello,

I am currently trying to create a graph that allows me to plot a range of quartiles and then highlight individual salaries and where they sit against those quartiles.

Here is an example of the table that i have:

Job TypeSalaryLQMedUQ
Head320000225000260000315000
Manager164000110000145000165000
Deputy128000100000120000130000
Jnr9500085000110000
125000



<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
The way that i would like to show it is by using an area graph for the quartiles and then a line graph to plot the individual salaries across it so it is clear in what quartile they sit. However, when i do this the area graph does not seem to plot itself correctly against the values in the table- for example, for the 'Head' row, the UQ starts at 500,000 instead of 315,000.

ANy help would be greatly appreciated!!

Thanks,
Emily
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,144,162
Messages
5,722,847
Members
422,460
Latest member
VBA_Noob01

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
Top