While trying to put together a few basic functions, I am having difficulty with conflicting approaches.
I would like to create Macros/buttons that create charts based on high lighted data, placing them in certain location/sheets etc. Hence an excel sheet with multiple lists of data, user could select a range and push a button.
I have tried recording, but I run into a few issues: Recording creates macros with set ranges, thus when I select different data and run the macro - it still uses the old data. This type of issue negates most record functions I try.
Also- I would like to create a chart template/macro that has a certain type, font sizes etc. I've tried, recording, using chart wizard etc and get stuck.
Anyhelp?
I would like to create Macros/buttons that create charts based on high lighted data, placing them in certain location/sheets etc. Hence an excel sheet with multiple lists of data, user could select a range and push a button.
I have tried recording, but I run into a few issues: Recording creates macros with set ranges, thus when I select different data and run the macro - it still uses the old data. This type of issue negates most record functions I try.
Also- I would like to create a chart template/macro that has a certain type, font sizes etc. I've tried, recording, using chart wizard etc and get stuck.
Anyhelp?