How do I plot a 45 degree line in EXCEL VBA?

's Computer Specifications

How do I automate plotting a 45 (1:1) degree line in EXCEL VBA?

Michelle

's Computer Specifications

Hi Micelle,

In A1: =ROW()
In B1: =ROW()
copy A1 and B1 down, let's say 20 rows.
Select A1:B20, Insert>Graph and choose a line graph

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"miriza" <(E-Mail Removed)> wrote in message news:F0D8684E-91AB-44F5-9693-(E-Mail Removed)...
| How do I automate plotting a 45 (1:1) degree line in EXCEL VBA?
|
| Michelle

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3D Scatter Line Plot in Excel - Wellbore Plot	KenN	Microsoft Excel Charting	0	12th May 2011 11:21 PM
Removing Plot lines between plot points on a line chart	JDKapono24	Microsoft Excel Charting	1	28th Jun 2008 06:06 PM
How to add a line plot onto a stacked plot in Excel	=?Utf-8?B?VmlqYXk=?=	Microsoft Excel Charting	1	14th Nov 2007 01:04 PM
how does one plot a line-column on two axes in excel?	=?Utf-8?B?Z2JydW5uaG9lZmZlcg==?=	Microsoft Excel Charting	1	7th Sep 2007 01:37 PM
How do i show a line of best fit in a scatter plot in excel?	=?Utf-8?B?U2hlbGJ5U2VuaW9yMDc=?=	Microsoft Excel Charting	3	25th Jun 2006 06:21 PM