Forum Widgets
Latest Discussions
Excel crashes whenever file tab is clicked
I have been having a lot of issues with Excel on a vm that we use, and I cannot try and fix these issues due to not being able to click on the file tab. Whenever the file tab is clicked, excel freezes and if anything clicked again goes to not responding. I do not get anything from windows diagnostics. I have also reinstalled Office 365 several times and excel always has this issue. the VM is a 2019 data Center and excel is 32 bit. running in safe mode does nothing. Book.xltx or Sheet.xltx is not in the XLSTART folder, if it was, I would have to wait for plant downtime to restart the vm. Deleted the excel key in HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel, restarted excel and issue still persists.
Excel charts: revenue and margins over a time period
Hi all, I want a chart showing the development in revenue and margins over a period of three yrs. I want the revenue to be marked on the left hand x axis and margins to be marked on the right hand x axis (secondary axis). I can't quite get it to look the way I want. See the attached picture. What I want is for the margins (currently shown as lines across the three companies) to show as lines across each company over the time period. So basically one line across company A, one line across company B and one line across company C. Appreciate any help! Best regards, Kris
PLEASE HELP ME. Excel Time Formatting Not Working?
PLEASE HELP ME!!! I created an excel workbook for tracking fitness workouts, I record the data such as weight lifted, number of reps, and rest times between sets. I formatted the cells so they express your rest times in terms of minutes and seconds (I used the custom "H:MM" format of time option). But whenever I record the amount of time you spend during cardio exercise, the formatting gets COMPLETELY SCREWED UP because when I type 28:44 (28 minutes and 44 seconds) of cardio duration, it instantly turns into 4:44 (4 minutes and 44 seconds). But if I type 20:00 (20 minutes) of cardio duration, it stays as 20:00 (20 minutes) and it never turns into something else. Why do some of the numbers like 28:44 transform into a complete different number when I enter them? I uploaded 3 screenshots below to better express what I mean. 'PLEASE HELP ME!!! Problem With Excel Formatting Not Working?
PLEASE HELP ME!!! I created an excel workbook for tracking fitness workouts, I record the data such as weight lifted, number of reps, and rest times between sets. I formatted the cells so they express your rest times in terms of minutes and seconds (I used the custom "H:MM" format of time option). But whenever I record the amount of time you spend during cardio exercise, the formatting gets COMPLETELY SCREWED UP because when I type 28:44 (28 minutes and 44 seconds) of cardio duration, it instantly turns into 4:44 (4 minutes and 44 seconds). But if I type 20:00 (20 minutes) of cardio duration, it stays as 20:00 (20 minutes) and it never turns into something else. Why do some of the numbers like 28:44 transform into a complete different number when I enter them? I uploaded 3 screenshots below to better express what I mean.
How to create a multi-tiered percentage-based bar chart?
Hello, I would like to create a multi-tiered percentage-based bar chart based on the data found below (test data evidently). Column B and C add up to 100%, Column D and E add up to 100%, and lastly column F and G add up to 100%. I would like each set of variables to equate to 100% on the graph, as the source data is percentage based anyways, but all be organized in their own separate row on the graph underneath the employee name. I have included a diagram drawn in MS paint to portray the desired output (with an accompanying legend). Thanks in advance! Employee Name Number of Sales Made % Number of Sales Made from Other Competitors % Number of Calls Made % Number of Calls Made from Other Competitors % Number of Individual Employees % (always is 1) Number of competitor employees % John 28.57% 71.43% 30.00% 70.00% 16.67% 83.33% Stacy 41.67% 58.33% 38.71% 61.29% 20.00% 80.00% Richard 47.06% 52.94% 47.06% 52.94% 14.29% 85.71% Andy 42.31% 57.69% 40.48% 59.52% 10.00% 90.00%Index & Match Formula Not Working
In broad terms, I'm on sheet 2 and wanting to show the contents of a cell from sheet 1. Basically, I want whatever is in column C of sheet 1 for the row that has column A in Sheet 1 matching A2 in Sheet 2 AND also has column B in Sheet 1 matching A1 in Sheet 2. I want the contents of that cell to show in Sheet 2. I've made this formula, but clearly I'm missing something (names of sheets have been changed, as the actual ones are people's names): =INDEX('Sheet 1'!C:C,MATCH('Sheet 2'!A1,'Sheet 1'!B:B),MATCH('Sheet 2'!A2,'Sheet 1'!A:A)) Any help would be appreciated.
