scatterplot

Tried searching the forums, but couldn't find anything. I have an XY scatterplot of data with data labels in excel 2010. The problem is that the data lables tend to overlap each other or they'll appear right on the data point and I end up spending excessive amounts of time formatting them...

I am trying to set the fill on different data series in a scatterplot and I don't want there to be any coloured border. I recorded a macro to get rid of it, but it doesn't do anything the macro gives me this: ActiveChart.SeriesCollection(1).Select Selection.Format.Line.Visible = msoFalse I...

I'm wishing to have a VBA code that will allow me to label data points on an XY-scatterplot. The labels I will to affix to the points are NOT the category (i.e., x-values) or value (i.e., y-values), but reside in a third column within the Excel spreadsheet. For example, if Columns A and B have...

Hi, I'm trying to color some datapoints in a scatterplot based on the color in the neighboring cell where the data is. I've written some code, but I'm not sure why it's not working. I don't get any errors, but the datapoints do not change color. Basically I recorded myself selecting a...

I am working on a project, and was wondering if there is a quicker/better/easier way to do it than what I have been doing. I have two sets of data - one for 2009 and one for 2010 - broken out by department (there are about 100 different departments with which I am working). The data sets...

I'm working on a scatter plot chart and I have 2400 rows of data. I have 2 columns I need to plot and I edit my X-values and Y-values for the series in the Chart Wizard but somehow it reads the x-values as the number of rows I have rather than actual x-values that I specify. It's strange...

:confused: Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value...

I know you can view various trend lines in Excel by adding a trend line to an existing chart. Furthermore, you can view the formula on the chart which provides the equation that describes the tend line shown. Background: In my model, I'm trying to identify numerous (50+) unique polynomial...