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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I plot a 45 degree line in EXCEL VBA? (https://www.excelbanter.com/excel-programming/375640-how-do-i-plot-45-degree-line-excel-vba.html)

miriza

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

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

Michelle

Niek Otten

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

Hi Micelle,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"miriza" wrote in message ...
| How do I automate plotting a 45 (1:1) degree line in EXCEL VBA?
|
| Michelle

All times are GMT +1. The time now is 03:20 AM.