View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucretia[_2_] Lucretia[_2_] is offline
external usenet poster
 
Posts: 1
Default how to print a chart from values calculated in macro


i am writing a macro to calculate a fourier transform. what i want to do
is make a chart (xy scatter plot) of values of one 1D array vs. values
of another 1D array without having to enter the values into the
spreadsheet. both arrays have the same number of elements. i cant find
this in the help files nor the VB textbook i have.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements