How to set up a graph?
Hi-
I'm using Excel 2002 and I'd like to set up an XY (Scatter) graph.
I have a worksheet with data in 50 columns by 40 rows. (days
outstanding)
Below this, I have a second set of data in 50 columns by 40 rows. (%)
I'd like to graph days outstanding vs. % for each of the 40 rows.
I know how to do this by setting up each series, one at a time, until
all 40 are done, but is there an "automated" way to set the ranges and
have Excel do it????
thnx
|