aggarwal18
New member
- Joined
- Aug 2, 2016
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi all
I am trying to create a scatter plot in excel and I am getting my rear kicked for such a simple procedure. My problem is I have a lot of data that needs to be compiled in a scatter plot and doing it manually will not be an option. My data kind of looks like this
This is just an example. I have files with close to 40 categories and have close to 200-300 files. So doing a manual insertion is not an option. I am trying to make a scatter plot which will make a plot with category 1 as the series title and plot x and y and then superimpose the same graph with a different color as category 2 and x and y and so on. Is the a way to automate the process?
Thanks
Abhishek Aggarwal
I am trying to create a scatter plot in excel and I am getting my rear kicked for such a simple procedure. My problem is I have a lot of data that needs to be compiled in a scatter plot and doing it manually will not be an option. My data kind of looks like this
Legend Title | X Value | Y Value | |
Category 1 | x1 | y1 | |
x2 | y2 | ||
x3 | y3 | ||
x4 | y4 | ||
x5 | y5 | ||
Category 2 | x2,1 | y2,1 | |
x2,2 | y2,2 | ||
x2,3 | y2,3 | ||
x2,4 | y2,4 | ||
x2,5 | y2,5 | ||
Category 3 | x3,1 | y3,1 | |
x3,2 | y3,2 | ||
x3,3 | y3,3 | ||
x3,4 | y3,4 | ||
x3,5 | y3,5 | ||
Category 4 | x4,1 | y4,1 | |
x4,2 | y4,2 | ||
x4,3 | y4,3 | ||
x4,4 | y4,4 | ||
x4,5 | y4,5 |
This is just an example. I have files with close to 40 categories and have close to 200-300 files. So doing a manual insertion is not an option. I am trying to make a scatter plot which will make a plot with category 1 as the series title and plot x and y and then superimpose the same graph with a different color as category 2 and x and y and so on. Is the a way to automate the process?
Thanks
Abhishek Aggarwal