Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar graph and line graph overlayed | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel |