Chart with both X & Y variable

K

Khawar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible? Variable X and Y data sources and Auto Charting 0
Can't get the x-axis to cross at value 0 for both y-axes 3
Charts-text for x & y axis and titles 5
Excel x,y chart type x range must be re-entered each series 1
Creating Scatter Graph Pivot Chart without autocalc on (x,y) values 1
Creating Scatter Graph Pivot Chart without autocal on (x,y) values 2
Relating x,y to left,top 1
Trying To Add a Line to an Excel chart using variable cell values 2

Top