Folks
I am trying to build a scorecard for my company.
Unfortunately I have a legacy of Word for reporting and am using linked images at this stage to replace the previous manually updated word charts etc.
My evil plan is to use Excel as a data source for all the various dots, charts, pie charts and columns representing stock tank levels etc.
I do have some code for changing colours of chart items based on values but it hard codes the values and steps through all teh charts in one shot.
Does anyone have code for manipulating charts based on individual limits set in a spreadsheet? (ie chart 1 has lower and upper limits of 25 and 75%, chart 2 has limits of 45 and 65% etc.
I am a little stumped as to how to grab data from the spreadsheet to manipulate charts in this way in bulk without running individual code snippets for each chart
I am trying to build a scorecard for my company.
Unfortunately I have a legacy of Word for reporting and am using linked images at this stage to replace the previous manually updated word charts etc.
My evil plan is to use Excel as a data source for all the various dots, charts, pie charts and columns representing stock tank levels etc.
I do have some code for changing colours of chart items based on values but it hard codes the values and steps through all teh charts in one shot.
Does anyone have code for manipulating charts based on individual limits set in a spreadsheet? (ie chart 1 has lower and upper limits of 25 and 75%, chart 2 has limits of 45 and 65% etc.
I am a little stumped as to how to grab data from the spreadsheet to manipulate charts in this way in bulk without running individual code snippets for each chart
