scatter

Good afternoon everybody, I am having an issue with a chart template. I am working on a scatterplot based on 36 observations, I therefore have 36 X and 36 Y displayed in two columns. I generate a scatter plot and I apply a very nice template to have a better visualizations of data markers. This...

Hello! Could the experts here can help with a strange Excel behavior related to graphing? The basic question: why do scatter plots appear rough or noisy for simple functions like y=sin(x) or y = mx+b when the ‘Smoothed Line’ option is OFF? The screenshots show a few basic functions.. y =...

Hi All, I attempted to post an attachment, but it appears I do not have this permission? I am attempting to fill the are under my XY scatter plot, but for some reason the area chart and XY scatter plot are just slightly misaligned along the X Axis. If anyone is willing to attempt to recreate...

Hello all! I searched the forum for an answer to my question couldn't find an answer that worked for me but maybe I did not search properly. I am having a hard time creating a scatter chart that works for my data. Perhaps I should choose a different chart type but my boss has specifically...

Hi there. I have put a file on the following link: https://www.dropbox.com/s/icu4rtgoy6oy3bw/Scatter%20Charts%20problem.xlsm?dl=0 I hope this is ok, as we are not able to post attachments. I am having some problems with some labels appearing on the scatter charts. If you look at the file on...

I am trying to create a scatter graph but cant seem to get excel to help me out! I want the axes to be like the chart on the left, but with the data labels to show the group names (eg a, b, c, etc). Trouble is, when I select the group names, the chart ends up looking like the chart on the...

Hi guys, I haven’t been on here for a while but I’ve been tasked with creating two graphs from my data set which is really puzzling me. Graph Number 1. I have a selection of Groups with different numbers within them. So A for example contains 5,000, B contains 7,500, C contains 10,000, and...

hi guys i saw somewhere that they drew a scatter chart for a formula for example y=x^2 in this way : they give starting point and ending point and how many point we want between start & end for accuracy . can somebody help me? ****** id="cke_pastebin" style="position: absolute; top: 0px; width...

Hello, I am working to create xy scatter line graph using two data columns. Since data ranges change occasionally, i need to plot up to last non empty cells. Any advice how to approach this? Also, is there way to create a message box that will ask for a chart title? Im am very new to VBA,so dont...

I am trying to create a scatter graph where the y-axis corresponds to SUBJECTID (in text format) and the x-axis corresponds to values associated to each of the different subjects, so that the graph displays horizontally-lined dots, each line corresponding to a subject identified on the y-axis...

VBA plot a Scatter graph data - X and Y axis data taken from sheet row by row The data is time series data thus each row of X and Y data must be plotted from the respective worksheet row (20 columns of data) This needs to be automated via VBA to accept the data row by row - wish to expand...

Hi, I have set of data and need to create scatter chart with two different color data sets 1. Basically I want to create a scatter chart with below data. Use 'price' as Y axis 2. If middle 'Sid' column got B then data point in scatter chart should be in blue 3. If middle 'Sid' column got S...

Hello! I have coordinate data (specific X and Y value) that I am trying to plot as a scatterplot. What I am plotting is coordinates for a location for every trial in an experiment, so it would look like this: <tbody> Trial X Y 1 504 340 2 507 338 3 518 335 4 527 333 5 539 331 6...

Please help! I have to finish this by tomorrow. How do I plot Date/Time vs. Temperature? I have a column of cells formatted like "1/1/2017 12:00:00 AM CST" and the other column simply temperatures "88.98468" I need temp on y-axis and date/time on x-axis. The times are in 5 minute increments...

Late at night and I'm at a total loss...failing on multiple fronts: both how to create the x-axis (which should be fiscal year and quarters, and then how to create the scatters for the 2 different groups (say Group A in blue dots, Group B in red)! I get the FY-FQ axis looking like numbers (0...

I have been using slicers in order to filter the data that I have displayed on a scatter chart. I was wondering if it was possible that when selecting multiple selections in the slicer, the different selections would show up on the scatter chart in different colours/markers. Or is there a...

Is it possible to create a line or scatter graph with text in the Y-Axis? I have tried a few times and it continues to associate a value with the text rather than show the text. Thanks!

Hello, How are you doing? I got an internship during the summer and one of the tasks that I had was to plot some data in Scatter / Bubble Chart, however, I still struggling with it. Just to give a short background about the data: The data were collected in a small-scale fisheries community...

Hi all, I have a really pressing question. I am currently undergoing my final year research thesis and have carried out a quasi experiment. Now I need to analyse the data but finding it very hard. I have no clue when it comes to excel or data analysis so any advice would be good. I have four...

Hello! I'd need to create a scatter chart and a bubble chart where each point/bubble is a standalone series. All series should have the same marker/colour/format and will have 3 values for the scatter (series name, X value and Y value) and 4 for the bubble (series name, x value, Y value...