I have solved this problem for an Excel course taught at my Company using the following resource: http://www.techrepublic.com/blog/microsoft-office/two-ways-to-build-dynamic-charts-in-excel/ I find the solution quite tricky to set up at first, but it works like a charm and avoids all VBA and Tables! Works for old Excel versions too.
One disclaimer is that it uses column grouped column charts with groups playing the role of a "series". It goes as follows:
Create a data range that expands downwards:
Next prepare named ranges that we will load into the chart. You create named ranges by clicking in the ribbon Formulas -> Defined Names -> Define Name.
Define the names within Sheet, and not within the workbook - it is a good practise to separate name spaces.
Create the following three ranges:
Next create a grouped bar chart and select data:
For the labels range, input the following:
etc for KPI2
Then add the horizontals similarly
Now you can add rows to your data table with KPIs for your new Company!