Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Cartesian Cell Names
Is there a way to get Excel 2007 to treat cell coordinates as Cartesian
coordinates instead? Id like to be able to input fill colors into cells using x/y numbers I know I could set up to columns. . . X and Y. . . and then enter in my numbers under them. And from there I could even create an XY Scatter Chart. That much Ive figured out but Id like to take this to the level where the output of this wouldnt be a chart but a specific cell location on a worksheet itself. Id like for the entire sheet to become a big Cartesian grid in itself. I dont know if I need to approach this from a VB Coding perspective, or if Excel has something similar already built in that will get me close. It seems as if it would. If anybody has any ideas Id like to hear them. Take Care, and Thanks if you can help, Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Cartesian Cell Names
Hope I am reading your question correctly:
In A1: D3 I have this data 1 2 3 4 5 6 7 8 9 10 11 12 The formula =INDEX(A1:D3,2,3) returns the value 7 So does =INDEX(A1:D3,F1,G1) when F1 have value 2 and G1 has value 3. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Jim D." wrote in message ... Is there a way to get Excel 2007 to treat cell coordinates as Cartesian coordinates instead? Id like to be able to input fill colors into cells using x/y numbers I know I could set up to columns. . . X and Y. . . and then enter in my numbers under them. And from there I could even create an XY Scatter Chart. That much Ive figured out but Id like to take this to the level where the output of this wouldnt be a chart but a specific cell location on a worksheet itself. Id like for the entire sheet to become a big Cartesian grid in itself. I dont know if I need to approach this from a VB Coding perspective, or if Excel has something similar already built in that will get me close. It seems as if it would. If anybody has any ideas Id like to hear them. Take Care, and Thanks if you can help, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a Cartesian Coordinate Plane? | Charts and Charting in Excel | |||
How to create Cartesian Plane | Excel Discussion (Misc queries) | |||
How to do a cartesian join in Excel? | Excel Worksheet Functions | |||
Cartesian chart | Charts and Charting in Excel | |||
Help Plotting Cartesian Coordinates | Charts and Charting in Excel |