Hello all,
Need a little help with designing my sheet - any help will be greatly appreciated.
So i have a table with a target for department A to H - the target is compared to the 'total performance' which is made from items 1-6.
I want to plot a line graph to compare the target to performance, but try and see how the performance will change if various scenarios were applied (e.g reduce item1 by 10%, delete item 2 completely, double item 4 etc). - i want to simulate one of these scenarios on the line graph (or a combination of more than 1), but then return the graph to original form again after i have viewed the graph
I have been playing with macros to apply the scenarios - but struggling to return the graph to original form after applying the scenario.
Any help will be greatly appreciated.
Thanks in advance
Need a little help with designing my sheet - any help will be greatly appreciated.
So i have a table with a target for department A to H - the target is compared to the 'total performance' which is made from items 1-6.
I want to plot a line graph to compare the target to performance, but try and see how the performance will change if various scenarios were applied (e.g reduce item1 by 10%, delete item 2 completely, double item 4 etc). - i want to simulate one of these scenarios on the line graph (or a combination of more than 1), but then return the graph to original form again after i have viewed the graph
I have been playing with macros to apply the scenarios - but struggling to return the graph to original form after applying the scenario.
Any help will be greatly appreciated.
Thanks in advance