I need to be able to automatically create a chart in Excel. The chart is
basically a 4 quadrant scatter diagram:
|
x | x
| x
-------------
x |
| x
|

The datapoints are determined by something like:
Data | X | Y
---------------------
Data1 25% 15002
Data2 63% 32404
Data3 51% 98011
.. . .
.. . .
.. . .
Data(N) % #

I've been plotting all this out by hand using the scatter chart but as I get
more and more datapoints the more time it takes which is why I'm looking for
a way to automate it. The solution created needs to be flexible enough to
work with a small dataset all the way up to a large dataset.

Thanks!

--It looks like the formatting is being changed when I submit this question
so the quadrant diagram isn't really showing up correctly.

you can also answer directly at
http://www.helpshare.com/qhome.asp?view=ViewQ&qid=2312 which would be better