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 ,
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?