Chart with both X & Y variable
 

I have Data organized as below.

Any suggestions how to display the profits while also showing the relation
between Rent (Left Column) and Sale Price (Top Row)

Rent/Sales $969 $1019 $1069 $1119
$28000 -6205020 -1513554 3177913 7869379
$29000 -8025020 -3333554 1357913 6049379
$30000 -9845020 -5153554 -462087 4229379
$31000 -11665020 -6973554 -2282087 2409379
$32000 -13485020 -8793554 -4102087 589379
$33000 -15305020 -10613554 -5922087 -1230621

Thanks
Best Regards

An "XY (Scatter)" chart?

Jerry

Khawar wrote:

I have Data organized as below.

Any suggestions how to display the profits while also showing the relation
between Rent (Left Column) and Sale Price (Top Row)

Rent/Sales $969 $1019 $1069 $1119
$28000 -6205020 -1513554 3177913 7869379
$29000 -8025020 -3333554 1357913 6049379
$30000 -9845020 -5153554 -462087 4229379
$31000 -11665020 -6973554 -2282087 2409379
$32000 -13485020 -8793554 -4102087 589379
$33000 -15305020 -10613554 -5922087 -1230621

Thanks
Best Regards

A 3D surface chart?

Luckily, your data fit into the limitations imposed by XL on a 3D
surface chart. For more see
3D Surface
http://www.tushar-mehta.com/excel/ch...ace/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have Data organized as below.

Any suggestions how to display the profits while also showing the relation
between Rent (Left Column) and Sale Price (Top Row)

Rent/Sales $969 $1019 $1069 $1119
$28000 -6205020 -1513554 3177913 7869379
$29000 -8025020 -3333554 1357913 6049379
$30000 -9845020 -5153554 -462087 4229379
$31000 -11665020 -6973554 -2282087 2409379
$32000 -13485020 -8793554 -4102087 589379
$33000 -15305020 -10613554 -5922087 -1230621

Thanks
Best Regards