scatterplot

  1. C

    Marker Borders "Marker Line" removing in VBA

    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...
  2. R

    Labeling data points on Excel charts

    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...
  3. L

    Help Custom Color ScatterPlot Points with VBA

    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...
  4. mchel_27

    Graphing

    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...
  5. C

    scatter plot chart

    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...
  6. E

    scientific calulations using scattter and trendlines

    :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...
  7. C

    Polynomial Regression Equation Formulas?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top