Question about Graphing in Excel

[ROAD_DOGG33J]

Basically I have a table that has 3 columns. 2 of them are necessary to plot the point and the third is a number associated with that point. I was wondering if there is a way to graph this?

 

[Matrixhasu77]

Yes, I believe you can make a graph by doing "Insert>Chart...>Chart Wizard" after selecting the data. It's been ages since I used Excel to make a graph though. I hope that helps.

 

[ROAD_DOGG33J]

That will only get the points on there. I need the 3rd value represented as maybe a name or the color of the point.

 

[Matrixhasu77]

That will only get the points on there. I need the 3rd value represented as maybe a name or the color of the point.

Are you trying to get the specific value to show on the graph then I take it?

What kind of graph are you wanting? If you are wanting a simple scatter plot with the values showing for each point, you only really need the data. The data itself is in turn used to label the points on the graph (provided it's a scatter graph) by turning on X or Y values under "data labels" when you construct the graph. You shouldn't need a third column specifically for the label of a specific data value provided you only want numerical values.

I'm not sure that really helps.

 

[ROAD_DOGG33J]

Yeah, I need a scatter-type graph with no lines. The thing is that the 1st two columns (x and y) are really only coordinates. So the third value is really the data I need to see if there is a pattern.

 

[Kylehnat]

Could you show us what you're trying to plot? I've done all sorts of weird stuff with graphs in Excel, but I'm not really sure what you're trying to do.

 

[ROAD_DOGG33J]

Basically ra and dec are kind of like degrees and z is the data I want at that point.

 

[Kylehnat]

Ah, I see. I'm not sure how to put custom data labels on charts in Excel, since I've never had to. There's probably a way to do it in MATLAB, since it can do everything under the sun. The tradeoff is that it's a pain in the ass to use.

 

[ROAD_DOGG33J]

Thanks for the help, I was able to find an add-in that can add labels

http://appspro.com/Utilities/ChartLabeler.htm

 

[Kylehnat]

Cool 👍