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.Chart from dynamic array challenge
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.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!
Help with data and visuals
I hope i can explain this right, i have data that shows 3 things: person, start date and end date: now i need excel to take this information and represent it as the following in the month tracker: It would look for the charts and figure out the timeline and add them to a row with the timeframe: example is Booy 15-0ct-25 to 23-oct-25 the char would go to the next one and add his information, I hope someone can help me. I just need it to populate the month tracker, Thanks
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%
Moving a column of text data into 3 columns of data?
I have a column of text data cells 1,2,3,4,5,6,7,8,9 and longer. I want to create 3 column of data to graph and manipulate Cell in Columns. 1,2,3 3,4,5 5,6,7 8,9,10 and longer. So i need to create 3 columns of data from 1 column of data. I am using Mac Excel 16 and I can not make this happen. I have tried all sorts of solutions. Help? Thank you,Need help creating a dynamic graph from data extracted from a pivot table
Hi experts, I have hourly data collected from our shared solar system (14 lots). I can get that data into an excel table easily, then use a pivot table to get it summarised by Date-Month.Day (rather than by hour) and Lot. A calculated column in the pivot table gives the percentage ratio of the solar power delivered each day to each lot. [Sidenote: The solar power is not delivered equally every day, but is demand based with an overall objective of eventually sharing the power equally, where equally depends on the strata lot allocations, so some lots get a different percentage than others. Furthermore, the distribution is split into 3 phases, where a given set of 4 or 5 lots share the same phase] I've added slicers to the resulting pivot so I can look at each month of data for each phase. [Note that the system went into operation on Nov 22, so the November data is only a few days, beginning Nov 22] What I'm trying to achieve is to get the data graphed to show the Ratio of Solar Delivered per day per Lot. Something like this, which is fine for Phase 1 for the month of November only: To create this graph, I used array formulas in some spare cells in the pivot table to tabulate the data like this: The table extends dynamically as I add months and/or phases to the pivot table display - which is great. Just what I wanted. BUT... the graph stays stuck on showing just the first four lots and the first 9 days because that was the size of the table when I grated the graph. I WANT THE GRAPH TO EXPAND DYNAMICALLY AS THE TABLE EXPANDS I've tried changing the Chart data range to accommodate the extra data, but if I then change back to a smaller set of data, the graph size does not change. viz- below is how the graph looks after changing the Chart data range to accommodate some extra data, then reduced to the original data set: I WANT THE GRAPH TO CONTRACT DYNAMICALLY AS THE TABLE CONTRACTS In other words, when I change the slicers to show the original data set, I want the graph to return to its original format ~------------------------------------------------------------------------------------~ I've read posts that talk about formatting your data as a table. Bit if I try and format by "helper" data as a table, I get the following warning: If I exclude the calculated headings, I get #SPILL errors ------------------------------------------------------------------------------------ I'm at a loss to work out how to create a dynamic graph. I'm hoping someone in the community can help - good luck and happy new year. And thanks for taking the effort to read this rather long post. If I can figure out how to add my source file to this post, I'll add it. In the meantime, you can view/download my source file here: https://1drv.ms/x/c/c95331b296c5ed04/IQCxxcpJWbyOTIXiDxyvmg9mAS5xcAADjTrP0JXBbs1IHBI?e=JJvVYH RedNectarChart linking with Name Manager
so it's known chart behave different than other items, i linked it to a box that indirect the limit of which it should take values from a column, like i used this code to do it: =OFFSET('Study '!$F$25,1,0,'Study '!$BD$26), but this fails when i want it to take starting and ending limit with offset command, it just re input values, like if i want beginning to be 100 and ending to be 300 it reads first 100 and then reread them plus the extra 200 so i have 400 values. is it possible to make it so from column F it starts taking values from lets say box BC and the ending limit to be from BD? i tried looking it up and figuring it but you know how it goes with charts
