“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to make a graph with the Y variable being "percent mass loss", where the X axis compares four different species among two different sites. I need my legend to be the four different sites, and I need the Y variables to show the different % mass loss among these four different species.

Solved by K. Q. in 11 mins

I need one cell to look at a specific range in a column, figure out if the date in those cells is between two dates and if it is I need it to take the value of the adjacent cells and sum them up. I have a column with dates, next to that a column with dollar amounts. I want one cell to make a sum of the amounts associated with a specific date range. Please help.

Solved by X. U. in 20 mins

i need the same expert back, time ran out before i could download and approve

Solved by X. B. in 28 mins

I need a PowerPoint graph formed from an excel spreadsheet I have attached. It should be labeled Actual occupancy and Actual ADR. On the left axis of the graph should be occupancy. On the right axis, it should be labeled ADR. On the left axis for occupancy, it should start with 50 at the bottom and go to 75 at the top. On the right for ADR, it should start at 50 and go up to 130. Occupancy is measured in % and ADR is in dollars

Solved by S. H. in 17 mins

I am trying to take info from one spreadsheet and have it be inputted into another number a spreadsheets based on certain criteria

Solved by F. J. in 25 mins

In this excel sheet, in "I" Column we have separate service lines and J column have different names, Can some one create a macro code where the code automatically selects each service lines and against name create a separate excel sheet in a folder . for example in "I" column if we select " Distributed Batch Scheduling" in J column we have two name Jayaraj , Rajesh and Selvam harish we want two excel sheet with name Jayaraj with 1 ticket and Rajesh with 3 tickets. same way for other metic. can some one help me on this.

Solved by D. F. in 20 mins

The chart shows locations of demand points and the demand for each point in the city. Assume that you will be locating two warehouses within the boundaries of the grid. What are the coordinates x and y for each of these locations in order for the total distance traveled by shipments to be minimized? Use the Euclidan distance formula D=SQRT( (y2-y1)^2 + (x2-x1)^2). Both x and y must be integer numbers. Make sure you experiment with different solving techniques (the value of the objective function must be less than 151).
(This question necessitates the use of the Solver tool in Excel, as well.)

Solved by B. W. in 24 mins

Yesterday, the last representative I worked with did not resolve my issue. I am requesting assistance in configuring a formula to auto-populate along with other cells when a value is selected from a drop-down box in another location on the spreadsheet.

Solved by B. B. in 11 mins

i want a to create a button that when clicked on you can choose a pdf file to embed into a single cell, i want to avoid colleagues choosing the insert.... object...method in excel

Solved by Z. H. in 19 mins

I need to know how to formulate calculations & subractions from columns

Solved by K. Q. in 25 mins