Hi, I have a question regarding a way to organize many scatter plots 'easily'. I am working on improving it to handle different time series and have not found a simple way for it to auto-update yet. let's say I would like to compare 500 time series that look something like this: Identifier Time A Value A Time B Value B Time C Value C 1 10 0,17 22 0,13 32 0,09 2 12 0,15 23 0,12 30 0,1 3 13 0,11 26 0,08 39 0,05 Also they could be anything from 5 pairs to 100 pairs long. I have tried organizing the data in two sheets, but I'd like to not have to plot each individual series. Any suggestions?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Scatterplot with multiple x and y values.

Thread starter solan
Start date Mar 25, 2014
Tags

multiple series scatter plots

solan

New Member

Mar 25, 2014

Hi,

I have a question regarding a way to organize many scatter plots 'easily'. I am working on improving it to handle different time series and have not found a simple way for it to auto-update yet.

let's say I would like to compare 500 time series that look something like this:

Identifier	Time A	Value A	Time B	Value B	Time C	Value C
1	10	0,17	22	0,13	32	0,09
2	12	0,15	23	0,12	30	0,1
3	13	0,11	26	0,08	39	0,05

Also they could be anything from 5 pairs to 100 pairs long.

I have tried organizing the data in two sheets, but I'd like to not have to plot each individual series.
Any suggestions?