Hi, first off I want to say I think you are genius lol. I am so lost on what I need to do and am super impressed at your skills.



I need to actually do up a bunch of different graphs vs. just adding additional companies to this existing one. So I need to pretty much mirror the original one you did (attached) but modify the pricing and maybe a few additional "companies" on some of them.

Any idea how to start? Outside of you creating the other graphs for me lol (just kidding) I don't have the foggiest idea where to even start.

Attached Files

Copy of MultiSeriesScatterGraph.xlsx (17.9 KB, 8 views)

Hi,

So I just watched a few videos to get a basic understanding on how to do a scatter graph. They make it so seem so easy as you just fill in data for x and y axis. I have done that which is attached. The values are actually plotted properly on the graph, the only thing is its all showing like its one company vs. the fact that there are 6 different ones. How can I modify this so that the legend shows 6 companies and different points of colour?

I am hoping to be able to start using this and modify it so I can get an understanding of what to do. I am struggling using your original graph and trying to change it up to make the 5-6 other graphs I need to do.

Help! lol

thanks.

Attached Files

Scatter Graph.xlsx (11.1 KB, 7 views)

In my last graph, you can select different service (a cell with data validation list at top of page - over the graph). You select there different service - you get a different graph in same report.