scatterplot

Hi All! Happy Tuesday! Thanks, in advance, for any support you can provide. The data below are all fictitious. I have been working on dynamically plotting data points in an Excel chart (scatterplot) based on specific conditions within my dataset. Specifically, my goal is to display data points...

Hi all, I have two sheets. Sheet 1 (“Overview”) contains raw data, Sheet 2 (“Charts”) contain XY plots. On sheet 1, I have a table with four columns. 1) Company, 2) Industry, 3) Metric one, 4) Metric two. Based on filters applied to the industry-column, I’d like the XY plot to automatically...

I have a question how to set up a scatterplot. I have a table with column A ID’s, column B percentages% and column C numbers. I want to plot numbers against % and show for each dot the ID. I have tried to do several things in the scatterplot add multiple series but ir is not working.

Hello, I created a table in that other people will not enter information in Sheet1 and this information will then be shown on Sheet 2 in ranking. Part of the ranking is a scatterplot where the data points are shown. The scatterplot should have labels, so it shows the name of the item. My...

I want to produce a scatterplot where someone can view student performance on different subjects by looking at different segments of the X-axis (classes --> categorical). Here's a portion of the data Class Student Score(%) A 1 0.64 A 1 0.70 A 1 0.95 C 3 0.28 C 3 0.55 C 3 0.80 The data is...

I have the data of following format.(2 Rows , 4 columns) csv file. Phylum,Abundance_in_Sample_1,Abundance_in_Sample_2,Abundance_in_Sample_3 Bacteria,6,5,7 I want to plot a scatter plot where Gradients are colored from low abundance (blue) to high abundance (red). Kindly help.

Hi all, I want to first acknowledge that I have also posted this question on excelforum.com. I am posting here as well because my question on the other site seems to be getting lost in the shuffle, and I am hoping for a reply today or tomorrow. Thanks so much for reading this :) So - here's...

I am trying to create a basic scatterplot. I have a column of USD and a column of months - specified in 1,2,3,4 etc(1 stands for Jan and so forth). I create the Chart and have USD on the X and Month in the Y Axis. How do I go about getting the average USD for month 1, the average USD for...

Hello, I'm trying to create a scatter plot with points that are named (i.e. identified by which row they come from). I'm trying to do this so my legend will indicate specific information about the points rather than just what their coordinates are. Below is an example where the first column is...

Hi Guys, I'm working on creating a scatter plot with lines graph to show both progression in levels for a person, year by year, as well as the performance rating that the person received that year. I'd like to do the formatting based on rating on a yearly basis (only one rating a year) and in...

Hello All, I have 3 columns: | A | X | Y | | 0 | 59 | 61 | |20 | 58 | 60 | |110| 59 | 60 | I want to add a series (a subset of data from columns X and Y) to my scatter plot based only on rows where the value in column A is <101. (The subset I want is Bolded above) This is way...

Hello All, Bare with me here :) I have 3 columns: | A | X | Y | | 0 | 59 | 61 | |20 | 58 | 60 | |110| 58 | 60 | I want to add a series (a subset of data from columns X and Y) to my scatter plot based only on rows where the value in column A is <101. (The subset I want is Bolded...

I am using Excel for Mac (2011) and I am having trouble getting specific dates on the X-axis to correspond with my Y-values. Can someone please advise? If you need further information please let me know. Thank you.

I have this chart and I'm trying to resize its points depending on the 'Size' values [D2:D8]. I found some code that should resize the points depending on some values, but it gives me 'Run time error 91 object variable or with block not set'. Here's the said code: Sub...

I am trying to create a x,y scatter plot of multiple series, each with their own x,y values. The data is organized as shown below, as (series name, x, y). I can create the scatter plot by adding each series to the chart, but there are hundreds of series and I need a faster way to go through...

I have two data series, showing the ranking of a number of factors before and after a vote. I want to show how the position of each factor changes after the vote. So far, I have put on high-low lines, which links the relevant points clearly. However, I want them to be arrows, always pointing...

I have different values for both X-axis and Y-axis. Eg: -- removed inline image --- If I were to change the range, excel will produce two graphs. How could I edit my code so that the x and y axis will change according to the values? 'Create Graph For Coil2 With...

Hey, I've created a program to calculate Coil Voltages. For each voltages, there are 256 points. The dots on the scatterplot is too big and currently I had a hard time on resizing it to be smaller. Those below are the codes on creating scatterplot for one coil voltage: 'Create Graph For...

I have the following vba code obtained from the macro recorder for changing a data series in an xy scatterplot to a black diamond. Is there any way to edit this so that it does it for all series on a chart? I have about 50 series and would like the macro to go through each one and do the same...

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