Get instant live Excel expert help to learn how to find range in Excel

I'm try to make a scatter graph using two sets of data, I've just made two other graphs and they have worked fine, but for some reason this third set of data just screws up the graph completely. It looks like the scale is completely wrong as my y axis data set goes up to 216 but the axis on the graph is 0 to 1 and then on the x axis is is 0-1.2 even though my x values range from 3-12. Ive tried changing the scale in the format axis and trying straight from word, both do nothing.

I am running a XNPV function, But I want to be able to select the range (values & Dates) based on a single cell with a certain number of months in it.

In cell G8 in the Summary worksheet, insert a date function to calculate the number of years between 1/1/2018 in cell H2 and the last remodel date in the Last Remodel column (cell F8). Use relative and mixed references correctly. Copy the function to the range G9:G57. Unit 101 was last remodeled 13.75 years ago. Ensure that the function you use displays that result.

In the Database sheet, enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter criteria as text only, without use of quotation marks. Be sure to enter the criteria separately in rows 3 and 4.

Sub ConcatWithStyles() Dim X As Long, Cell As Range, Text As String, Position As Long Range("A3").Value = Space(Evaluate("SUM(LEN(A1:F1))+COLUMNS(A1:F1)-1")) Position = 1 Application.ScreenUpdating = False For Each Cell In Range("A1:F1") With Range("A3") .Characters(Position, Len(Cell.Value)).Text = Cell.Characters(1, Len(Cell.Value)).Text For X = 1 To Len(Cell.Value) With .Characters(Position + X - 1, 1).Font .Name = Cell.Characters(X, 1).Font.Name .Size = Cell.Characters(X, 1).Font.Size .Color = Cell.Characters(X, 1).Font.Color .Strikethrough = Cell.Characters(X, 1).Font.Strikethrough End Sub

How do I resolve this error from an import data template. The start of the destination range specified lies within an existing external data range.

I need help building a countif formula, the formula needs to count how many inputs within a certain range =<3 (e.g. =COUNTIF(C75:BJ75,"<3")) and also needs to add 2 to this value every time there is the number 12 present in this range

click cell c6 in the data worksheet and insert a column. Type series name in cell c6. click cell c7 in the data worksheet and insert a lookup function that identifies the series code, compares it to the series legend, and then returns the name of series. Copy the function you entered from c7 to the range c8:c22. Change the width of column c to 18

I have created a matrix table to calculate the amount of staff i need for a certain range of sales. Currently i have a drop down that is divided by job description and it calculated the staff needed for the specific job based on its matrix. I would like to add a new option on the drop down for "Total" that would calculate the employees needed for all jobs combine.

I have a line on a scatter plot with smooth lines, I located the point where the line seems to connect, and I want to divert that than at that point and select data, then add, and input my range. I am having trouble doing my range, excel keeps telling me error. I want to make each segment of the line a different color with the series. How do I do the range.