Thread
:
able to automatically create a chart in Excel
View Single Post
#
2
Tushar Mehta
Posts: n/a
able to automatically create a chart in Excel
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
Reply With Quote