LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
dot plot - single x axis location with multiple y axis dots EJF Charts and Charting in Excel 2 March 23rd 06 02:15 AM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"