I am working on creating a excel template file that includes charts generated from the data added. One of the charts displays trending data over 12 months for an unknown number of products. The example below shows a piece of the 12 month breakdown against three products:
Product A Product B Product C 6/1/2013 1588 3488 1391 7/1/2013 1821 3629 1460 8/1/2013 1857 3208 1598 9/1/2013 2601 2496 1325 ...
I can easily create a chart with the existing data. However, if I want to add another column for a 4th product (Product D), I am unable to get the chart to automatically add it as a new series. Is this possible with Excel (I am currently using 2013)?