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 Type Salary LQ Med UQ Head 320000 225000 260000 315000 Manager 164000 110000 145000 165000 Deputy 128000 100000 120000 130000 Jnr 95000 85000 110000 125000 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel Graph Help

Thread starter EMY245
Start date May 21, 2014
Tags

area chart graph quartiles tables

EMY245

New Member

May 21, 2014

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 Type	Salary	LQ	Med	UQ
Head	320000	225000	260000	315000
Manager	164000	110000	145000	165000
Deputy	128000	100000	120000	130000
Jnr	95000	85000	110000	125000

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