Correlation Study with Filters
Dear Experts , I have a data like below( Attached worksheet) And want study the correlation between SNR[0~3], there will be 6 combinations as below:- I want make like this but with Filters/Slices for the "File.Name" & "SSB or TRS" & "Carrier Index", different colors for different Carrier Index(0 &1) Thanks & Regards Anupam Shrivastava
Creating a pie chart for peoples attendance
Hi guys I was wondering if I could ask for a bit of help with a excel document I'm trying to create. I created a document that lets me enter sick days, annual leave days, late starts and early finish days along with overtime hours worked and I would like to create a pie chart that represents those days but for the life of me I can't work out how to do it. What I have is 1 overview sheet which shows the total view of the 12 months then I have 12 sheets 1 for each month which lists staff names along with the mentioned days off. The overview sheet takes the totals from the 12 months and lists them in a nice easy to read view. On the right side of the overview sheet I have another page where I have a drop down box to select the staffs name which then fills the boxes containing the mentioned days off coming from the overview page. I also have a number of working days being calculated from July 1 2025 minus listed public holidays and annual leave days we had during the christmas factory shutdown. This is where I would like the pie chart to be in the empty space below here. What I'm aiming for is to have the pie chart dynamically change based on name of the person selected from the drop down box. Ideally I would like the pie chart to represent the number of working days as the whole pie then sick days, annual leave days, late starts and early finishes as a piece of the pie along with the name of each pie section. The overtime hours worked doesn't need to be shown on the graph as thats just reference. Any help would be greatly appreciated. I can upload the document as I created a temp file and changed the names so as not to break privacy rules. I don't see a place to attach the file though unless I have gone completely blind. Thanks so much for your help.
Excel Map - One region is recognized but not showing up in color
Hi, As shown below, I am trying to map out the number of farmers in our data in each of Georgia's regions. Samegrelo Zemo Svaneti is recognized and the data label appears but the color does not. If I change the map to show only the regions with data, it does show in color but I need the full country map.Chart updates inconsistently when dynamic array resizes
Hi (Excel 365 v2601 b19628.20132 Current Channel / Windows 11 25H2) Initial post edited (& cross posted here on Jan 29, 2026) after further investigations In B6 below an array that dynamically resizes according to the 'START Year' & 'TOPN Cat' variables. The Chart is setup as follow: Select an empty cell > Insert 2-D Line chart Right-click > Select Data… > Chart data range > Select the Serie names & Values (C6:G12) Click Edit under Horizontal (Category) Axis Labels > Select the range with the Years (B7:B12) Check of the Chart data range: Changing 'START Year' works no problem: the Chart data range & Horizonal Axis Label range are properly updated Changing 'TOPN Cat' (the array resizes horizontally) screws up the chart: The Chart data range is properly updated but the Series & Axis Label ranges don't update accordingly Q: Am I doing something wrong, facing a limitation or is this something else? Tried to attach the sample file 3 times... it's available at: Dynamic_Chart_Challenge.xlsx Thanks & any question let me know Lz.
Format Data Labels - Value from Cells
I have a spreadsheet (below) that I wish to show in two different ways: The actual numbers in each of the cells Domestic, Overseas, EU, and Non-EU as shown. The percentage values as shown in the %age domestic, %age overseas, etc.. Using the Format Data Labels and selecting Value From Cells, I can do this for any 2 of the 4 columns. However, when I try to select Value From Cells from the third and/or fourth column, nothing appears in the bar chart - it's completely blank (apart from the background colour.) I have uploaded the failing sheet, which can be downloaded by https://c3a-cyprus.org/test-work.xlsx. I'd appreciate any thoughts TIA Nigel
Help needed with IF and COUNTIFS Formulas
Is anyone able to advise the following formula: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & V3,$D5:$D15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & V3,$H5:$H15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & V3,$L5:$L15, ">" & V3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & V3,$P5:$P15, ">" & V3) Is there a way to simplify this? Is there a way to make this more accurate? Cells in column G & H, I & J, O & P are using the following format: =IF(C6="","",C6+E6) Cells in U4:CC4 are using the following format: =COUNTIFS($B$5:$B$15,$R$4,$C5:$C15,"<=" & U3,$D5:$D15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$G5:$G15,"<=" & U3,$H5:$H15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$K5:$K15,"<=" & U3,$L5:$L15, ">" & U3)-COUNTIFS($B$5:$B$15,"="&$R$4,$O5:$O15,"<=" & U3,$P5:$P15, ">" & U3) Cells in U5:CC15 are using the following format: =IF(U$4>=$T5,1,"") My issue is is when I put in the three break times, the mid break comes out at a shorter time. My other issue is is that when I put in the times in row 5,6and 11, the data is coming up as a combined data in rows 5, 6 and seven on the page two. Just for reference, "page two" is the same spreadsheet. What I need to happen is that I enter in the shift start time and finish time. This then populates through to Break 1, 2 and 3. The Time entry is the time the break starts. ie: 1 hour after start of shift, 1 hour after coming back from break, etc. The break entry is the duration of the break taken. ie: 30 minutes. Once all the info is put in, the relevant "Time Block" on "Page 2" shows a 1. What is happening at the moment is that when I enter all the time data, the time blocks are not populating correctly in accordance to the entry. Basically, If I have numerous people on shiftI need the time blocks to show where I have shortfalls in shift cover and not having too many people on break at the same time. IE: Link to Live Copy: https://www.dropbox.com/scl/fi/eur1j526htu1j8a4d4290/Staff-Breaks.xlsx?rlkey=r4tm9xts4tonofpa2th2cusfw&st=nueyk0d7&dl=0 Any ideas would be greatly appreciated.Formula result not showing in cell
Attached is my code and the formula result showing 50%. But in the cell where the formula is located, it displays a 0%. I have tried formatting the cell to be a number, percentage, and everything else, yet it still does not put the formula result in properly. Am I missing something?
Request: Please Professionally Enhance My Gantt Chart Template
Hi everyone, I’ve created a basic Excel Gantt chart template for suppliers to use when discussing project timelines with landowners. The chart lists tasks on the left and shows the duration of works by month from October 2025 to April 2026. My Excel skills are quite basic, so I’d really appreciate if someone could directly improve the template for me. Specifically, I’m looking for: A more professional and visually appealing layout Clearer formatting for tasks and timelines Automatic highlighting of active months for each task Conditional formatting to make the chart easier to read Any other practical enhancements that would make it more effective for supplier discussionshttps://docs.google.com/spreadsheets/d/1SdPU8HEsHDjOHljwYsPnRmRHHNrJ5Whq/edit?usp=drivesdk&ouid=104511246399228274463&rtpof=true&sd=true This is only a template and contains no sensitive data. I’ve attached the file—please feel free to make changes directly to the chart. Thank you very much for your help!
