Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
X & Y Coordinate return value
I have a problem that needs a creative solution. I have a data set as follows.
Column A Column B Column C x John 20hrs x Tim 4hrs x Mike 5hrs y John 7hrs y Tim 9hrs y Mike 40hrs Basically think of colA is the project and B is the resource name and C is the number of hours in that position. My end result should be something like this: Project Name x y Tim 4 9 Mike 5 40 John 20 7 I can try to reformat the data if needed but can anyone offer a solution? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find an unknown x coordinate from know y coordinate of curved line | Charts and Charting in Excel | |||
coordinate of cursor on a chart | Charts and Charting in Excel | |||
How do I set up a Cartesian Coordinate Plane? | Charts and Charting in Excel | |||
Labeled Coordinate Plots | Excel Discussion (Misc queries) | |||
Creating an x,y coordinate chart | Charts and Charting in Excel |