Thread: Scatter Charts
View Single Post
 
Old 02-22-2019, 09:20 AM
RhondaPCanada RhondaPCanada is offline Windows XP Office 2010
Novice
 
Join Date: Feb 2019
Posts: 9
RhondaPCanada is on a distinguished road
Default

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
File Type: xlsx Scatter Graph.xlsx (11.1 KB, 9 views)
Reply With Quote