 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-31-2005, 12:05 AM
|
|||
|
|||
|
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 
|
|
#2
10-31-2005, 09:05 AM
|
|||
|
|||
|
Re: 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 <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 >
|
|
#3
11-03-2005, 12:15 AM
|
|||
|
|||
|
Re: able to automatically create a chart in Excel
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? >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
