Search results

My current chart shows data by period over the course of six years. I need to change it to only show YTD total for the six years. I would like to be able to have the sum range increase for all columns as data is added to the 2019 column. For example, when data is added to Period 08 for 2019, I...

Ahhhh, I did not download your file. My bad. I have used a label column in other tables and charts and that is the perfect solution. Thank you, G, for your timely, efficient, and effective assistance! Gratefully, k

Hi again, G. I had unselected "Show #N/A as an empty cell" so there is no label for those cells now. Please see the attached edited file and note the error in C2. Thank you for your patience as I try to keep up with your suggestions!

Thank you so much! This formula seems to beautifully with the exception of #N/A in the first row (B2.) In this case (I've uploaded the sheet to reflect same) an error is returned. I cannot delete the #N/A because both columns are charted. Again, the problem arises when #N/A is in the first row.

I have a report that includes an accuracy column. A second column calculates the average accuracy for month 1 through the current month. In order for the chart to display (or not display, actually) the months with no data, I've entered "#N/A." The charts work properly for the monthly accuracy...

Bosco, thank you so much for your prompt reply. Your solution worked perfectly in my worksheet.

Thank you, Narayan. I was not able to get this to work for me on this sheet. However, Bosco's solution was successful. Thank you so much for taking time to respond to my request for help.

I have a worksheet that is populated from another workbook and has two total columns. There are two columns for each period -- quantity and dollars -- for each period, so the total columns correspond to the appropriate column periods. The sum formulas work if data is in the same workbook, but I...

Yikes! Just had another issue come up. I am sorry if my description is confusing. We use OneDrive, so the other file that my cells are linked to has our company name in it. One of the total cells was returning an average where there was only one value. When I analyzed the new formula that uses...

Thank you, all, for your quick responses and for helping me solve my worksheet dihlemma!

Thank you, Narayan.

Thank you, Chihiro! I now understand more about using the "" and will remember your information. I chose your alternate/3rd suggestion and it worked beautifully! How grateful I am.

Thank you, Thangavel. When I change it to a direct link, a "0" appears in D12 and D14! And I am only having the problem in Sample B file and not in the same worksheet in Sample A file.

I have three workbooks with identical template sheets and formulas. I don't want the quarter totals to show until the quarter is complete, so the formula I have had success with is =IF(D14>0,SUM(D12:D14),""). The three periods are in rows 12, 13, and 14. Two of the three matching worksheets...

Thank you for the simple suggestion. I will definitely adjust my formulas.

Good morning, vletm. I have been unable to answer your message; however, I will respond as soon as I have a chance to test your versions. Thank you so much for your help!

Thank you, vletm. I really like your version. I one question so far -- it seems you did not address the pink-shaded box at the bottom of the Speed Performance tab. That updated information needs to be displayed on the page each month. Also, do you have any idea of why Excel freezes with this...

Yes, I have tried that for this workbook.

The attached workbook is a mini version of the real one. The Exec Summary and dashboard sheets are created from data on 12 other worksheets. I deleted all but one to keep the file upload small. The report is updated monthly to show the most recent 12 months of data. All worksheets are part of...

Yes, Hui! I couldn't figure out how I could manipulate a calendar year. Thank you for your prompt reply! Have a great day.

I need to have a multiple level axis with fiscal years and months (July-June.) Is this possible?

Thanks again, Luke, for the simple solution.

I've been assigned an addition to the formula. Since we don't schedule the machine for more than 80% of capacity, that needs to be included in the formula as well. Again, this is time-sensitive. I appreciate so much having such a great resource of amazing Excel gurus. :)

Thank you so much, Luke. You're the best!

Luke, That is great, but my table is transposed -- your columns are my rows. Would you mind editing for me? I'm in a time crunch (as I assume most folks are) and I think this will work perfectly if transposed. Thank you so much for your prompt response.