Chart Two Data Series

[Jarke]

Hi,

I have two different data sets that I want to plot in a chart. If my first data has 500 cells, and I want my second data to continue after these 500, how do I do that?




Yes I could put them in the same data entry with an ";", but I also want another colour on the second data set, and I don't believe I could seperate them this way(?).
Thus, two "Legend Entries (series) seems to be the correct way.

Thanks in advance.

 

[Worf]

Duplicate post: https://www.mrexcel.com/forum/excel-questions/1015167-two-dynamic-data-ranges-chart.html