line charts

I have line 9 charts, updated with weekly KPIs on Mondays. I took over this spreadsheet once it was converted to FY. One line of one chart, once the data is updated, creates a new data point but I can not not select Data Label. I can click on it, but it fails to turn on the data label. All...

Hi guys, I have created this book with a ton of formulas and macros within it which boils down to a line chart to compare sales of 2 objects over months dynamically. My problem is that if the sales figures for the two objects in the same month are too close to each other after entering new...

I am looking to plot a line graph with upper and lower limits (Ranges). Attached is the target view (PNG). The value that I have, has positive and negative values. Hence showing upper limit and lower limit range in the line chart is a bit complex. Attached is the excel sheet(Sample.xlsx) with...

Hello everyone, I'm working with a line chart that (dates on the X axis and some series of data in the Y axis), when i add new columns of data (new dates with data), the x axis extends, but the chart area does not "adapt" to it, so the new part of the chart with the new data doesn't "fit" the...

Greetings all - I have looked high and low and can see that a lot of people have asked about how to keep a line chart from plotting blank cells, but I seem not to be able to nail it down in any effective manner. I have a column that is 25k rows. Each cell has a formula that produces a...

Hello, I've been trying to get a line chart to hide 0 values. I've tried forcing the formulae to make a blank cell and for a NA() but the chart still connects 0 values.- (Please see video link below) Any help on how to solve this would be hugely appreciated...

I have the following code that returns an error, "Method 'MaximumScale' of object 'Axis' failed", on the line in red: With ActiveSheet.ChartObjects("Chart 3").Chart dblXScale = (.Axes(xlCategory).MaximumScale - .Axes(xlCategory).MinimumScale) / LArea.Width dblYScale =...

I am stumped by a question on a potential employer's Excel test. The objective is to create a graph showing each particular product's percentage of total month's sales, for a 12 month period. The data set is thousands of lines, each showing sales for each month for a particular product in a...

Hi everyone, I have a spreadsheet in which I have created a line graph from containing 9 columns and a few hundred rows so far of data. Example below - (please note managers can have multiple scores on any one day and different managers can be audited on the same date) Date; Area; Event...

Hello everyone, I am enrolled in an online math program and need to submit a geometric graph. It needs to have an x and y axis, but nothing fancy - it will just be a few line segments. I cannot find a way to do this in Excel (I have the 2011 version). Is there a way? If so, how can I do it...

<TBODY> Plan</SPAN> POC</SPAN> Setup</SPAN> Reaff</SPAN> Jan</SPAN> 50.00%</SPAN> 10.00%</SPAN> 15.00%</SPAN> 10.00%</SPAN> Feb</SPAN> 40.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> 20.00%</SPAN> Mar</SPAN> 30.00%</SPAN> 30.00%</SPAN> 25.00%</SPAN> 30.00%</SPAN> Apr</SPAN>...

Hello, I have just really started to code on VBA but mainly from looking through such forums and using code from other macro's. I have the following problem and feel i am just missing one simple piece of the puzzle as they say. I need a macro when activated will do the following; will look...