Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Gantt Chart with variable width columns - is this possible? | Charts and Charting in Excel |