I am working on some charts for financial reporting. One of them shows some values for individual companies.
I will need to add new companies on a monthly basis, and would like the diagram to automatically create a new data series when I create a row for a new company in my Excel sheet and insert data in it.
Alternatively, I can insert 12 new empty data series beforehand, in which case I'll need to know how I can keep the empty series invisible in the legend until they contain data.
Does anyone know how to solve this?