1. B

    Plotting two non linear curves and extracting an average percentage imporvement

    I have two sets of data on excel with differing X and Y values and I am looking to draw comparisons and get an average % increase in flow for pressure over the range. Basically I did two experiments and want to compare the two and somehow quantify the improvement made statistically from the...
  2. M

    Plot dots on a bar

    Hi there! Please help :) I have a graph with salary range and I want to plot my employees as dots on a bar per grades accordingly. I think I did all right, but my dots (employees) appear on a right side of the graph and not on the bars ( salary range). Both Employees and salary range are primary...
  3. M

    How do I get a label in a scatter plot instead of "Series 1 Point"?

    I've got a scatter plot and when I hover over a point, it says something like: Series 1 Point "1.03" (1.03, 4.12) Series 1 Point "2.7" (2.7, 3.06) I'd prefer for it to say: Thomas (1.03, 4.12) Leslie (2.7, 3.06) I can get the labels onto the chart, the problem is when hovering the mouse...
  4. S

    Scatter Plot X,Y Coordinate Number of Occurrences

    I am looking to build a scatter plot to illustrate how many times an X,Y coordinate appears. So, if I have 15 occurrences of 2,3 then I would like to see 15 points at 2,3 on my chart. If I have 3 occurrences of 2,1 XY corrdinate, I want to see 3 points right there. I need this to be a scatter...
  5. A

    Assigning macro to SCROLL BAR/SPIN BUTTON

    HI, I have X,Y,Z coordinates of points(10 points) on a line. This line changes according to Time.. for each time change line changes and points on it also changes. Suppose it changes 5 times So I will have 5 such XYZ values for those 10 points. I have data for each time pasted in different...
  6. C

    Scatter Chart Plot Order

    Hi, I am plotting a scatter graph with values in column C vs column E. There are formulas from c1:c2000 and e1:e2000, and they have iferror statements to hide as "". I would like the chart to populate automatically hence the 2000 rows, even though just say 123 rows have actual values (the rest...
  7. A

    VBA re-position (center) x,y axis labels based on height,width of inner plot area of a chart

    I'm trying to figure out how to use VBA to center or reposition the axis (x and y) labels based on the height and width of a chart's inner plot area. Any help or input would be greatly appreciated!
  8. I

    Modifying Contour Plot with VBA

    I have a surface contour plot as a chart sheet. I need to be able to modify the number of series (20-200) and the number of data points in a series(200-1200). Do I have to do this one series at a time or can I just specify the rectangle that contains the data?
  9. M

    Step plot without dates on the x-axis

    Hello, I am attempting to create a step plot while using the following data shown below. I have been unable to so far because my x-axis values are not dates. <tbody> x-axis y-axis 0 25.85 0.67 25.85 0.67 -63.69121262 3.68 -63.69121262 3.68 44.58121262 4.35 44.58121262 4.35 -6.74...
  10. xeven_

    Plot an HMA "Hull Moving Average" on my line chart

    I have excel 2016. Can I plot the HMA "Hull Moving Average" on my line chart? The formula they gave is: HMA= WMA(2*WMA(n/2) − WMA(n)),sqrt(n)) If so how do I enter it, as I have never done this before? Thanks
  11. W

    How to Adjust the Axes to Accurately Show Data [Box Plot]

    Hello, So, I am trying to create a box plot of a statistical breakdown. My statistical breakdown does have negative values and I was able to make a box plot to account for the negative values by using a first and secondary axis. Right now, my problem is that I am not sure how to adjust the box...
  12. R

    Plot blank X-axis values

    Hi I am trying to plot daily values. The table value for the x-axis consists of a if statement that returns "" if a certain condition is not met: =IF(A52<='By category'!$E$3,Sheet4!A52,"") My problem is that for all the cells that are false (""), an empty space is plotted on the x-axis. So if 5...
  13. C

    Scatterplot treats letters as 0 numbers, how to prevent that?

    I have same data points from equation =IFERROR(K3+Q3;""). When I plot these numbers and "" blanks into scatter plot, "" blanks are treated as 0 numbers. Is there any way to prevent that?
  14. M

    Pivot Chart plot area exceeds 100%

    Hi I've got a Pivot Chart which shows certain metrics for different categories in percentage terms. None of the percentage values exceed 100%, but the chart goes up to 120%! Is there a way I can reduce plot area so it only goes up to 100%? Thanks
  15. S

    Excel Radar Chart - Remove Dummy node (parameter)

    Greetings! I am plotting a radar chart with 6 nodes (based on each of the parameter values). The Excel plot rightly plots the dimensions on 6 different nodes, but also creates a dummy node axis, without any parameter. Is there any advise on how to remove this 7th node (with the 6 parameters to...
  16. M

    Assistance to write a Macro that turns multiple lines of strings into one string based on corresponding ID#s

    Hi all! New to the forum, and I have a question about creating a macro. We have techs in the field collecting data about timber. Each day, we export that data to spreadsheets (images of the relevant sheets below). The way the recorders work, a certain field (Plot) has data (comments)...
  17. M

    Reformatting a chart - Strange issue

    I have a macro that does some reformatting of a chart (on it's own chart sheet) that changes adds a footer, put the plot area in a specific area (for page to page consistency), axis formatting, legend format. My issue is that the macro must be run twice and with a manual input (Input box) to...
  18. M

    Additional Range (series) with each data points in graph

    Is it possible to add additional range value in the same graph points? For example in the second plot (1, 107.6) (8, 107.6) (7,105.6).. so on instead of the first figures 1,8,7, I need to plot data from a different range: 300, 250,250... so on So the result should be (300, 107.6) (250...
  19. R

    Chart which shows frequency of each pair

    I have a data set, part of which looks as follows: <colgroup><col span="2" style="text-align: center;"></colgroup><tbody> X-axis Y-axis 50 50 50 100 50 100 100 50 100 100 250 100 250 250 250 250 500 100 </tbody> <tbody> 500 250 </tbody> <tbody> ... </tbody> Because I...
  20. T

    Add multiple series to chart with loop function

    Hi, I have been struggling to add a loop function to add 107 series to a chart without manually adding in each one The X and Y data are in Columns B2:B8882 and C2:8882 and each series I want to plot is 107 data points. Total 83 series. Below is the code I have so far. it seems to work..ish...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...