i want to write a code that generates data and add a chart.
i tried recording a macro (subroutine) but i read that excl2007 has problems.
so the x values go from 1-100 on column A and y=(2*x)+7 on column B.
then from this data i want to add an xy scatter with smooth lines. then i want to format...