scatter

I would like to build a scatterplot where each icon is a simple arrow. The arrow would change orientation based on a given value so, for instance, if the value were above 80 the arrow would point upward but under 20 would point straight down. Is there a way to use the arrows, either the ones...

Good Morning, For work, I am trying to graph profitability by state (could be product line, customer, etc) with Net Sales on the X axis and Operating Income on the Y. When trying to graph this in excel, it treats the selected data as two seperate series and doesn't plot based on the values...

Hello! I am trying to build a dynamic scatter block for reaches in Rivers The basic set of the data is as fallows: River : Reach : X : Y : Bear 1 0 156 Bear 2 10 158 Bear 3 20 162 Bear 4 30...

I am trying to create a scatter plot with two different series on it. (Both can use the same y-axis). The x-axis data is the same for both series. The Y-axis data is in two different columns. Like this: <tbody> x y1 y2 100 2 2 250 2.5 4 1000 3 6 5000 3.5 8 </tbody> Instead of...

Hi, I never really use excel, nor am I any good at it so this question may be seem stupid to many of you. Basically for a school project, I had to make a questionnaire and retrieve data and then plot it in excel, I'm trying to find out if internet speeds at a student's house affects how much...

As title suggests... I am reporting on the amount of certificates issued over a period of time. Basically the government stopped released data on the amount of one type of certificate being issued during this period and started releasing data on another type. I am having trouble displaying this...

given 100 samples, to calculate: numbers of hours spent on study is dependent on numbers of hours spent on social networking site. <tbody> x (social networking site) y (study) x^2 xy 6 4 36 16 24 6 4 36 16 24 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 3 36 9 18 6 2 36...

Hello! I need the data points on my second axis to align with the bars on my primary axis. So the purple triangles need to line up to the center of the purple bars and the gray squares need to line up to the centers of the gray bars. There was an addin for 2007 that let you manipulate data...

I am looking to create a chart of type xlXYScatter and insert a shape (e.g. triangle) at each point, then color each shape using RGB. I have yet to find out how to do this. Is this possible in VBA? Any guidance would be appreciated. I am only at the point where I have the chart defined and I...

Hello, I am creating an application to model probability distributions, and I had an idea to allow the user to SKETCH probability distributions intuitively by clicking and dragging the mouse to trace the curve in an embedded chart object or chart window. I need to be able to get an array of XY...

Hello, I am working on a scatter smooth line chart and I am having an issue with the X axis. I have 5 points on my charts and excel is doing an interpolation to get the smooth line. Values one the X axis go from 0 to 6 while I would like to customize it to have: "Put 40" for point 1, "Put 25"...

Help!! I have plotted the age vs number of siblings in a scattergraph. If I then hover over the bottom point, it gives me the value (2,1). Is there any way I can get it to show the name "George" instead? Much appreciated! <tbody> Name Age Number of siblings John 12 4 James 7 2...

Hi, </SPAN> I am currently working on a stakeholder mapping and I am using a scatter chart in Excel to do so.</SPAN> I succeeded in doing the mapping and placing the stakeholders according to the rating I gave them. However I would like the shape and colour of the markers to depend on the data...

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

I am trying to develop a x-y scatter plot for a set of data. I have created the chart. In column S beginning in cell 2, I have the values I want on my x-axis. These values are in the following form: Date_time frame. For instance, S2 contains 6/13/2011 8AM-10AM, S3 contains 6/13/2011...

I have reached the capacity of my capabilities and need the assistance with creating an Excel Chart. I have a table of test data with the following five columns of data: HEADING (Value 1, ....) "Data point labels" (A, B, C, D, E) "Minimum x-value" (30, 20, 29, 32, 28) "Maximum x-value" (75...

I have reached the capacity of my capabilities and need the assistance with creating an Excel Chart. I have a table of test data with the following five columns of data: HEADING (Value 1, ....) "Data point labels" (A, B, C, D, E) "Minimum x-value" (30, 20, 29, 32, 28) "Maximum x-value" (75...

Hi This is my first post here, so I am anxious to get this question figured out. I have imported 2 x-y files into excel. The first is the coordinates of a set of about 50 points on an image. The second is the coordinates of the same points, but at different location (i.e. they have all moved...

I’ve encountered what to me seems to be a very strange problem. I have an Excel worksheet with the prices of the 16 stocks currently in my portfolio, charted on a daily basis – that’s 16 different charts (XY scatter) of day vs. price data. I’ve been updating this worksheet daily for several...

Hi, I was just wondering if anybody knew of a way I could format the colouring of the plot area of an xy chart on Excel 2000. I'm aware of how to change the colour of the whole plot area, however I am looking to use 3 different colours to highlight whereabouts someones score point lays -...