# plot

1. ### How can I create a Dynamic 3D plot in Excel?

Hi All I would like to create a 3D plot, let's say a 3D frame ( just a connection of lines) that needs to be demonstrated in 3D and can be plotted by giving the coordinates of the connecting points (x,y,z) the coordinates should be written in the cells in that sheet, that when I change them...
2. ### 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...
3. ### 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...
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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!
9. ### 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?
10. ### 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...
11. ### 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
12. ### 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...
13. ### 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...
14. ### 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?
15. ### 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
16. ### 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...
17. ### 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)...
18. ### 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...
19. ### 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...
20. ### 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...

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...