plot

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?

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

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

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

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

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

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

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

It has been a while since I have been this stumped.. I am trying to compare points values in 2 series so I can adjust the position of data labels so they do not overlap. This works well for all but one of my charts, which after some troubleshooting I learned is because it is evaluating them as...

<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody> Plot No Plot Size 1 117 2 110 3 175 4 348...

I am trying to Create a Bubble Chart With the following data I would Like the x-axis to be the top row (Red Numbers) and the y-axis to be the Left side row (Blue Numbers) with the bubble size being the data in the middle. I have been unsuccessful in having Excel Plot this data correctly...

Hi. I have tried to build a code for creating an xy scatterplot. I have two columns where the values that I want to plot starts in cells W10 and AC10. The last cell used in the plot may differ from time to time based on manipulation in other parts of the worksheet. For the values in column AC...

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

Is this plot realizable in Excel without any additional software?

Hello, I've been searching for a while, but I haven't seen something quite as complex as my question... I'm trying to create a chart that combines columns and scatter/lines. I have an x-axis that is years, and I have a primary and secondary y-axis. I'm wanting to plot one data set to each...

I have 2 sets of data, for 2 indicators, over time. Format shown below (of course, the data sets are much bigger) Data set 1 (indicator A) <tbody> City 2009 2010 2011 2012 2013 2014 2015 2016 2017 Airdrie 1 2 3 4 5 6 7 8 9 Brooks 9 8 7 8 4 2 1 2 5 Calgary 4 7 4 3 4 8 7 6 1 Duncan 7 5 6...

Hello all, I have used this forum as an Excel resource for years but I am having one of my first major issues with the Excel Scatter Chart trying to plot an exponential trend-line with one of my data sets. See below: Basically, the exponential trend line will not plot on the second chart, it...

How can I get the value of the point that I have circled on the attached graph? i have the data, I will plot the curve, then how can I get the value?

The problem I have is already stated in the title - I have a loop generating 18 series in my code and I'd like all of those 18 series to be plotted on one graph. Somehow I don't know how to do it. It's probably a simple and obvious mistake, but I fail to see it. Hopefully someone could point it...

Hello, I have data consisted of 18 columns. From these 18 columns I need to produce 9 graphs. However, i dont need to use entire columns for those,only last non empty cells. For instance, i need to take a value from last nonempty cell from a column A and B and use those two points to construct...