able to automatically create a chart in Excel

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

How do you get a four quadrant scatter chart if all your values are
positive?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <5376B7B7-3587-41FC-8766-AE1F99CA0EAB@microsoft.com>,
tamccann@discussions.microsoft.com says...
> 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
>

I've seen charts like this where the vertical and horizontal divisions
were at the average or median of the X or Y values. We may never know,
since it wasn't stated in the original post.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Tushar Mehta wrote:

> How do you get a four quadrant scatter chart if all your values are
> positive?
>