Search results

Simple table below showing results, but I need formulas. Additionally, 1st shift capacity used and % capacity used cannot exceed machine capacity 1st shift and 100%. Production Units Required 150 Machine capacity - 1st shift 100 Machine capacity...

I need to create a sheet/table showing capacity for machines on first and second shifts and I need to compare usage to available capacity in both whole numbers and percentages. We will always fill first shift to capacity (100%) before producing on second shift. I need formulas for: Capacity...

Thank you, Narayan. This does work; however, the end users want to see the area grouped with the reasons. Is using the location as the report filter the only way to prepare this? When I filter a reason, the area doesn't show.

Thank you, Debra. I've uploaded a copy of my file with random values and generic descriptions. I look forward to your comments.

My Pivot Table layout: REPORT FILTER: blank COLUMN LABELS: Values ROW LABELS: Location Description, then Reason VALUES: Sum of Cost, Sum of Qty I have sorted my table by location descriptions in descending order of sum of cost and all locations with reasons with cost and quantities are filled...

I am actually using the Daily Rate for this report. I'll also play with adding all three categories. Thank you again, Jason.

Thank you, Jason. I tried your suggestion of moving Years to the filter box and it gave me a nice graph of months as totals of all years. This is a great help; I was stuck. I will definitely create a dashboard sheet with these three charts (one for each category -- new orders, produced, shipped...

I have sales, production, and shipment data for several years that my boss would like to see in YoY to see if there are trends relating to seasons, months, etc. I'm wondering if the best way to display the charts is as 12 small charts (one for each month/period) on one sheet for each category --...

Thanks, Luke. The charts are on separate worksheets. I made all column widths the same on the data worksheet, but it had no bearing on the chart alignment.

I have several charts on separate tabs that require monthly updates and printing onto transparencies to be overlaid. I have ensured that all plot areas are the same size by entering the dimensions manually. However, they are not lined up on each worksheet so they do not line up when stacked. Can...

My files were finally successfully uploaded to dropbox. My original file: https://www.dropbox.com/s/cxcwbudwo8mw29y/Capacity%20%26%20Plan.xlsx My answer to Faseeh's post: https://www.dropbox.com/s/7grj7s00iyb3x0g/Stacked%20Chart.xlsx Thank you, Kimber

I'm having trouble uploading, but I will keep trying. In the meantime, let me try to better explain what I need to do. For each machine there is a capacity. I need to show it as a stacked column at 80% capacity with the remaining 20% as a different color. This will NOT be a stacked percentage...

I have been charged with creating a stacked column chart with clusters for comparison. I have 13 Machines and I need two clustered columns for each -- one stacked for capacity (80% + 20%) and the second for items assigned to that machine. I've been able to create a stacked column chart for the...

Thank you so much, Hui. It worked beautifully and your explanation was perfect.

Faseeh, I've created a new worksheet using your formulas, but I couldn't get the second and third boxes to work. Would you please take a look at what I have and tell me what I'm doing wrong? I haven't used indirect before and I guessed at the target cells when I copied to my worksheet. Thank you...

Thank you, SirJB7 and Hui. Hui, your solution is great. I was stuck thinking I needed a pivot table and couldn't step back and see any other solution. I have one further question. I'm thinking about making a sheet for only when an entry appears (sometimes there is no data for a product in any...

I have financial data from a manually entered sheet provided by another department. I need to subtotal expenses by category for all products as well as by product for all categories. From the example you will see that a category was not provided for every product. This is an urgent need for my...

I have many different reports and graphs that I create from many data sources. Most data is used for more than one report or chart, and historically, my predecessors entered the data into each report separately. Obviously, this increases the chance of human error and requires more steps for...

Thanks, Luke. I thought perhaps I should use OFFSET which has worked for me in worksheets where my data was in columns. I tried to use OFFSET for rows, but I couldn't get it to work properly. I will attempt to set up the dynamic named range as explained and hopefully I will be successful!

I have a data for several products (rows)for each month (columns.) At the far right, I have the following columns (formula in parentheses): TOTAL (=SUM(M3:V3), 12 PERIOD AVERAGE (=X3/12), 6 PERIOD AVERAGE(=AVERAGE(R3:W3)), AND 3 PERIOD AVERAGE (=AVERAGE(U3:W3)). The worksheet is cumulative, but...

Montrey -- no worries. I must have made a mistake that I corrected, because they work great now! My boss is very pleased, thanks to your help! Thank you and Chandoo for this great resource.

Thank you for your quick response, Montrey. Your solution works like a charm (I changed "<" to ">" to achieve the red goals) when there is data in every cell. However, there is not data for every day. These days are being plotted as zeros so both series are showing up on the graph. Can...

I apologize if this has been addressed previously, but my searches (based on what I thought would work) yielded no results. I have a chart that graphs a daily rate in percentage form. The horizontal axis is the date and the vertical axis is the percentage. The GOAL is <1%. My boss has...

Thank you, Luke! I had the formula correct; however, I didn't format the cell correctly. :)

I'm not sure how to phrase my question. I need to have variances show up only as a +/- from "1". In other words, 1.02 should show up as +.02 and .98 should show up as -.02. Your expert help will be greatly appreciated!