Scorecard pie, column and spot colour changes


New Member
Sep 28, 2007
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

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...