I could now see what was in my previous example.
I did it as simple as possible, so companies list was entered directly into Data Validation List source (select a field/range with data validation, and then from Fata menu Data Validation).
As you did write, that you want several different graphs with same data structure, then I added some features to my example, and attached the edited workbook.
In PriceTable I added a Service column. On PriceGraph, you select a service, and pricing graph for this service is displayed.
For companies and services, a separate registry sheets are added. You register company (sheet Companies) or service (sheet Services) as 1st step. Only after that you can select it in PriceTable.
The PriceGraph data table is now fully dynamic. It supports currently the number of displayed years from 5 up to 10, and the number of companies up to 10.
|