scatter plot

I'm trying to create a scatter plot to show to plot sales of products against two dimensions, average price and sales quantity. The scatter plot does this well, but I want to label both ends of the axis so that they show this range: Low Price < - > High Price Low Quantity < - > High Quantity...

Hi There. When I create a scatter plot graph and then rotate the horizontal axis (which contains dates & times) so they are 90 deg, the date & time seem to be covering up the legend at the bottom of the graph and I don't know how to fix that...any help is appreciated! I have made scatter plot...

Hello, I have a scatter plot and would like to add a vertical line with a value of 270 to it. Is there a way I can do this? Here is what it looks like so far. [/URL][/IMG] Thanks!

I'm making a program that will rearrange scatter plot labels so they don't overlap. It's almost finished, but there are a few more kinks I need to iron out. 1. For some reason ActiveSheet.ChartObjects(1)'s dimensions are not right (I have only one chart on the sheet). From what I saw the height...

Hello, I'm using Excel 2008 for Mac & cannot figure out how to add a data label to an XY scatter plot that comes from a 3rd, separate column. I have 3 columns of data: (A,B,C) Labels, X values, Y values When I select the Data Source for the Chart, there is a greyed out box for Category X...

Hi all, I'm currently making an excel workbook where a user inputs a range of data which gets processed and reorganised into a table like the one below found in the "Intermediate" sheet in the workbook. There can be anything from 1 series to dozens, even hundreds. <tbody> Name Y1 Y2 X1 X2...

I need to be able to generate a scatter plot with the following data: 3 columns, 1st column is project name, 2nd column is feasibility, 3rd column is financial impact. Using the 2nd & 3rd columns as x-y coordinates, plot the x-y point using the 1st column as the x-y point label. Any ideas how...

Hello experts, I am having issue with a scatter plot graph that I am trying to make in excel. I am comparing woodpecker holes to the elevation at which they were found at. I was told by my instructor to place the holes on the y axis and the elevation on the x axis. However, in doing so I am...

Hey, so I am using the macro from MS's website to label a scatter plot. Unfortunately, it is only labeling the first 4 points. Does anyone know the solution to this / how to edit this macro to include a different range of data? Sub AttachLabelsToPoints() 'Dimension variables. Dim Counter...

I need a scatter plot that will leave out any values at 0

I need a way to make a customized legend for a scatter plot, is there any way to do that through VBA? I have a scatter plot with some points highlighted green, and some points grey depending on the user selection and need to be able to create a legend based on what the user selects (e.g. Green -...

I have an XY Scatter plot chart in Excel in which the X-axis represents sales dollars and the Y-axis represents profit margin. I have several thousand data points, but I need to be able to only look at sub-sets of this data which I have by adding a filter to my data in a different tab in Excel...

Hello, I am making a mortgage calculator that you can use to compare two different scenarios and have the results displayed on a graph. The problem is that Excel is plotting the data based on the location of the data for the x axis and not the value in the cell. I have a balance in one column...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I have a scatter plot of X and Y data points. Each point is made up of some number of items. How can I weight the points so that the trendline doesn't count a point that is made up of 10 items the same as it counts a point that is made up of 100 items? An example of my data: X .... Y ...

I have an xy scatterplot graph. I would like to add a straight vertical line and straight horizontal line through a point/series of my choosing on the graph. Each point on the graph is a different series, btw. I would like to be able to do this with a macro, but any help would be appreciated. I...

I have a problem with the way dates are being displayed in the x-axis of an XY scatter. The x-axis data is being read from a column with Date (dd/mm/yyyy (English UK)) format using =Data!$A$2:$A$803. The dates in the column start at 24/10/2008 up to 28/10/2011. The dates in the plot read...

Hello, I am using excel 2010 and I am making a scatter plot of the elevation of a course. My scatter data is selected as follows : Distance from start (X axis)-:--0---5---23---150---217--... Elevation (Y axis)-----------:--3---3---10---28----15--... I want to do 2 things to add to the visual...

I am looking to create a scatter plot where each point would be a .jpg that is loaded based on a specific condition. For example, if the X axis referenced months of the year and a point was on x=12 (december), that point would be an image of a Christmas tree. If the point were on x=7 (july), a...

Some background: I have 40 individual data points that I am plotting on a scatter plot in excel. As I add them, I am having to go, each time, and update the format of the data labels. What i need is only a label and no data point or line to appear on the scatter plot. I want it to have a...