I am trying to use a macro to make a lot of graphs and format them from a sheet of data. I am able to make a relative reference macro work with formatting difference cells (e.g. highlighting) but when I try to make it work with a graph it still uses absolute references to make a new graph. I can even make a single macro which has relative references working with cell formatting but it is using absolute references for graph making. I have no idea what is wrong.
What special procedure do you need to follow to make a relative reference macro work when making graphs?
What special procedure do you need to follow to make a relative reference macro work when making graphs?
