Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis)
Excel 2003 SP2
WinXP Pro SP2 1.5GB RAM
The standard Excel mapping doesn't seem to easily accommodate this, unless
I'm "lost in space..."
I need to graph some datapoints in a line-graph. Here's the situation
that's similar to daily temperature, humidity, barometric type of data in
VARIOUS columns
Rows 1:4000= (A=Day of week; B=Date (Mon-Fri, generally but excludes
holidays and 'special' days)
Columns A:AC contain the actual data in groups of 3, 4 or 5 columns
G:I=B=x-axis (date in mm/dd/ccyy format); G=value for Y-axis,
H=value-statement1 (not needed for graphing), I=Value-statement2 (not needed
for graphing)
J:N=B=x-axis (date in mm/dd/ccyy format); J=value for
Y-axis,K=value-statement1 (not needed for graphing), L=value for x-axis (this
is using a different calculation for this group of data (J:N)) Note: Columns
H and K are value-statements and they may be different value-statements. I
don't need to have anything to do with these value-statements relative to the
graphing.
O:Q=O=value for Y-axis
R:T=R=value for Y-axis
U:W=U=value for Y-axis
X:Z=X=value for Y-axis
AA:AC=AA=value for Y-axis
Hence, what I'm attempting to graph are the Y-axis (Any one of columns G, J,
O, R, U, X etc.) vs the X-axis (Row B). How can I do this i) one group at a
time and/or ii) all groups on the same graph?
Note: If I can't easily do it Excel, just recommend something that will.
I'm more interested in the results than 'forcing' Excel 2003 to do the job(s)!
TIA!
|