Ok.....
As I learn more about VBA, it SEEMS as though most everything that can be with formulas/formatting can be done with VBA - and to a 'higher' level.
Is this true with charts???
I am creating "template file" that is used to standardize nomenclature before pricing/vetting/importing inventories ---- many variables of non-standard Make/Model/descriptions (my biggest headache with acquiring new accounts).
The below image is an example of a chart I created to ensure I'm "above the estimated trend (of daily progress needed to achieve goal).
Can a similar chart be 'coded' in VBA so the "targeted average trend" (ie grey dotted lines) are automatically populated based upon the start and dates?
fyi - chart dates are: due by 7/9, but my target is 7/5 (the vertical dotted line).......gotta be better than expectations
As I learn more about VBA, it SEEMS as though most everything that can be with formulas/formatting can be done with VBA - and to a 'higher' level.
Is this true with charts???
I am creating "template file" that is used to standardize nomenclature before pricing/vetting/importing inventories ---- many variables of non-standard Make/Model/descriptions (my biggest headache with acquiring new accounts).
The below image is an example of a chart I created to ensure I'm "above the estimated trend (of daily progress needed to achieve goal).
Can a similar chart be 'coded' in VBA so the "targeted average trend" (ie grey dotted lines) are automatically populated based upon the start and dates?
fyi - chart dates are: due by 7/9, but my target is 7/5 (the vertical dotted line).......gotta be better than expectations
