On 6 Aug., Excel 009 wrote: > > > I have the following data and want to create a scatter chart. > > > I am using either 2003 or 2007. > > > > > > Person X1 X2 > > > ---------- --- --- > > > a 2 4 > > > b 8 2 > > > c 9 3 > > > d 1 5 > > > e 8.5 1 > > > > > > I want to put the values (a, b, c, d, e) from the Person > > > column next to the data point. For example, d for > > > the (1,5).
On August 09, Stuart Redmann wrote: > > > > You can do the following workaround: Make the chart an ordinary > > XYScatter chart and add one series for each data point: > > > > Sub CreateChart() > > [snip] On 9 Aug., Rajan_Verma wrote: > I don't have a Very Good Experience with Charting with VBA and I > have tried this Macro Exist in trail mail, its giving an error > "Series Order Must be An Integer 0 to 255" , Can anybody explain this Most probably you have hit the limit of 255 series for a chart, since my macro tries to create a series for each row of the selected range. If this is a real problem, we would have to change the code in such a way that more multiple charts are created that are placed at the same location. However, I tried to create a chart with 400 series and the error message I am getting is more cryptic "Run-time Error 1004". So probably you have done something else. Could you post an example worksheet that shows this problem? Regards, Stuart -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
