LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Charting Arrays

Have your arrays been populated?

Note that the data properties of the series are limited in how many
characters you can use to define them. If you have long numbers (remember
that most non-whole numbers may take up to 16 characters), the number of
points you can describe within this limitation may be much smaller than you
expect. Here's an article about this issue:

http://peltiertech.com/Excel/ChartsH...ChartData.html

The best approach is to dump the arrays into worksheet ranges, and chart
these ranges.

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


"boyze" wrote in message
...
I am trying to xy scatter plot with pre-defined arrays. A sampling of the
code is below but it does not recognize the arrays. Please advise.

Thanks in advance.

Dim Shear() As Double, NodeCoordinates() As Double
Dim MyNewSrs1 As Series
Set MyNewSrs1 = ActiveChart.SeriesCollection.NewSeries
With MyNewSrs1
.Name = Shear
.Values = Shear
.XValues = NodeCoordinates
End With



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arrays Brendan Vassallo Excel Discussion (Misc queries) 4 February 23rd 06 02:27 AM
Need help with arrays (I think) rbhedal Excel Worksheet Functions 3 October 19th 05 07:24 AM
3D Arrays DB Excel Worksheet Functions 2 October 10th 05 03:50 PM
Arrays Dan Excel Worksheet Functions 3 September 15th 05 07:36 AM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"