Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dot plot - single x axis location with multiple y axis dots | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel |