Excel PivotTable Keyboard shortcuts
Hi, I used to make a pivot table, Press Menu Key > Press M( Summarize Value By ) and click on the option ( Sum, Min, Max, Average ) However on Excel 365 its not clickable anymore, I have tried to restart the pc, Open different excel workbooks and even tried a different pc, Could there be an option I need to toggle? As you can see the options are grayed and not clickable. keyboard shortcuts used to be (Menu Key > M > S, M, I ) I still can summarize values but i have to do it manually with the mouse As the only way to click on those options now is to click on the Value field settings from the pivot table
Populating a table based on data in another table
Hi, I'm creating a personal budget sheet where i have one tab that tracks all transactions (example entries below). This tab will have ALL transactions. I'd like to have a summary tab where I show calculations and graphs based on a selected year and month. Is it possible to filter for year and month and display those transactions only in the summary tab? The issue i'm having is if i use the FILTER function, it doesn't return an array so I can't reference the table again for something else. I also can't filter for both year and month, i've only been able to filter for one or the other with this function.
How do I make a line chart ignore empty cells and NOT log then as 0?
Hello, I made a line chart and I want it to log a potential of 16 data points, but those data points will be filled in over time so I want the line chart to only graph the real-time data for the number of cells that have been entered. For example if cell 1 is 200, cell 2 is 225, and cell 3 is 250, and cell 4 is empty I want the line graph to chart 200 to 225 and then 225 to 250 and then just end at 250, NOT drop down to 0 for 4 to 16. How cand I do this in excel office 365 please. The methods I have found via google do not work. For example, I found a method to "ignore gaps", but that option isn't actually available to choose in 365 so how else can I do it please? Thank you! Jay
excel trening i am new in plat form
Grate Let's dive into a discussion about Excel . its such a powerful tool. and there a lot we can explane Here are a few ket topic that might interest you 1 excel formola And function ; How do different formulas work[ VLOOKUP,INDEX\MATCH, SUMIF] and what are some advance formulas you see in your daily tasks
