Plot series from Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to plot a series from code. What I want to do is plot some horizontal lines that do not change
For example I the y values will be say 50 for any given y value
Another way to think of this is I want to add horizontal gridlines at pre-determined points
Any ideas on how to do this

Bruc
 
Turn on the macro recorder (Tools | Macro > Record new macro...) add
the series by hand, and turn off the recorder. XL will give you the
necessary code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top