scatter plot

I have a scatter plot that is working the way I would except for when I set the lines property to msoTrue it creates a line vertically for each point on the x-axis but also then connects one point to the next as shown in the attached image. The goal is to make it where the line will stop at the...

I want to make a VBA code where both the x and y range are set from a different sheet (sheet2). The x range is dates and will remain in the same column no matter which dataset is imported into (sheet2). I know how to have a fixed y range from (sheet2) but I want the y range to change based on a...

I have a Scatter plot with 16 different series, 8 have Markers with no lines and 8 have lines with no markers. The data displayed comes from a TABLE, and I use a series of SLICERS to filter the plotted data. Occasionally when turning on and off buttons in a slicer ALL plotted series are...

I’m trying to use the data (see images below) to have three data points for each dot on the scatter diagram. I need each series element to be custom selected data (not fixed label) so that when I hover over the dot all three data points are visible. I can do this manually; however, I want to do...

Hello All, I am attempting to automatically plot scatter plots on each tab in an excel workbook. I wanted some help in scanning each worksheet to see if data is present, then plot the scatter plot based on the number of valid data found. For example, in this spreadsheet: There is 2 valid...

Is there any way to highlight areas on scatter plot based on the concentration to show distribution density. Commonly as density scatter plot as provided examples. kindly help.

Hi, I usually can select a column of data, then create a scatter plot from that data with each value being plotted on the y-axis (and the x-axis corresponding to each point's row). However, when I try this now, it is not working. If the column has a header, it just puts EVERY value into the...

Hi guys, I have an issue with this chart. I have these data for the "Lorenz curve" The first for the X and the second for the Y, Now I don't understand why the chart is not representing a correct connection in the last point. The last point is X=100% and Y=100% Why the chart is...

Hi, I have 8 scattered plot charts, all containing more than 300 dots.. This means that I cant use ordinary labels, because it destroys all visibility of the chart. So I need to hover the dots to see the label data. This works good but I cant manage to get the names of the items on the...

Good Evening, I'm in a bind and need to create a graph in excel tonight and I'm a little lost. I can create simple graphs no problem, but have no clue how to graph the below. Basically, I'm needing to graph patient depression levels throughout their admission to discharge from our facility...

Hello, I have created a scatter plot and graphed the line of regression in Microsoft Excel for my data set. I have been trying to figure out how to add prediction intervals to the chart for two days now, and I can't seem to figure it out. I can find confidence intervals, but that's not what I...

Is there a way to make the timestamp on the x-axis, the value on the y-axis, then the data points be the employee and differentiate different employees with different colors? In short, I'm trying to see if different employees are consistent across time with their values. I'm not certain if...

I am trying to draw walls in a building that the user inputs. The only way I can think to do this is with a scatter plot with each wall being its own series so that each wall can have its own trendline and data label. For now, the user can input 125 walls. I'd rather not take the time to...

I have a scatter graph which works fine with vba. And I managed to change the colour in the middle of the marker but the border is another colour and so the marker is now two colours. I have the following part of the code: Sub MySummaryGraph(i As Long, cht As Chart) With cht With...

Hi, I have a series of values for a scatter plot. For some of the values I have created this formula to return values: =IF(LEFT(D43;4)="-N/A";"";D43) When a cell is -N/A the value for the scatter plot is blank but it doesn't work with with the diagram. All I can do now is to delete the formula...

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

how to plot time series data in excel? i have some data set like this : day between two dates are not fixed, sometimes 2 days, sometimes 3 days, .. 5 data are collected on certain day: 29/03/2013...26/03/2013 ...and so on.. thanks in advance for any help!!:confused::) <tbody>...

Hello Excel Folks, I would like to create a script that would color points on a scatter point by a value (1 through 8). The data setup is straight forward ... a X values column, a Y values column, and a Color column (which contains the values for each color). The Peltier Tech created...

Hi, I am trying to create a scatter plot but have run into some issues. I have 2 columns - 1 I want for the y axis, and 1 for the x axis. However, my code makes the chart so that the x axis is how many rows of data there are (0 to 6) and then plots 2 lines with data on the y axis. How do I fix...

I have a scatter plot, sale price (x-axis) and discount (y-axis). Is there a way to quickly get other information, such as customer name, for that data point? Such as if I select that single point it will give me not just the x and y values, but other information for that row of data in Excel...