This will detail how you can get series that are dynamic, and change based on what is in your data, as well as an accompanying legend.
Note that this does not allow you to have a dynamic number of series, just change what the content inside of them is.
For example, lets say we have the following data, and we want to have a seperate series for each entry in column A, and show the grouped results by column D.
We would then need a series for Canada, Kenya, and Britain.
Now normally what we would do in our series is something like this;
But this would not work if we have series where the country data could change, as if Canada is replaced by United States, there would be no way for the formula to pick this up.
-First, create a table with the same number of columns as series you would want;
Set the Properties up like this;
-Then, in the formulas for the columns, do this;
This grabs each country in column A
-Set the Indicator conditions for each column to change it to a different background color that matches the color in the chart of that series;
-Add your chart, with the desired number of series, and make sure that in the Properties tab you are not showing a Legend
-Set up your series formula to be based upon the legend table we built earlier;
-Make sure that each series is set to have the same color as its legend, via the Properties panel
And now you have your dynamic series chart, that will change as the values in the data change;
Hope this helps, and happy Klipping!
Technical Support Specialist, Klipfolio
Dynamic Series for a Bar/Line Chart