charting
1694 TopicsCan't edit charts - all options greyed out
Hi - I've recently been upgraded to Office 365. I've got a regular reporting spreadsheet, with charts that need updating. However, I can't edit any of the charts! I can't right click anywhere on the sheets containing the charts, and all the options on the 'Chart Design' and 'Format' ribbon tabs are greyed out. The spreadsheet isn't protected, and I don't think its shared with anyone. Any clues?Solved86KViews0likes16CommentsRecurring issue I'm experiencing with charts that are moved to a dedicated chart sheet.
This is also happening to my students in my Excel for Agriculture courses: they send me their assignments, and while the charts look perfectly fine in older versions of Excel, in my Excel 365 I cannot see them properly. As a test, I even opened files that were working perfectly just a week ago, and now my own charts appear exactly like the image I attached. Needless to say, these are not corrupted files, the data source is fully verified, and everything else is in order. The only workaround I found was to insert a new regular worksheet, move the charts to that sheet (where they display correctly), and then move them again to a new chart sheet. After doing that, they look fine again, just as before. Before anyone asks the obvious questions: I have written four Excel books and have been teaching Excel for Agriculture for 20 years, and this is the first time I’ve ever seen something like this. I urgently need a solution. At this point, it makes no sense to keep paying for a Microsoft 365 subscription if this continues to happen. Please, if possible, translate any replies into Spanish. Thank you!47Views0likes1CommentCreating 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.Solved116Views0likes3CommentsCorrelation 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 ShrivastavaSolved150Views0likes2CommentsData Formatting
Dear Experts, I have a Data like below :- Each row can have 1 or more RNTIs( seperated by ",") and their DCI( UL_01 or UL_00), I want to put them in a format like in Col - I~P gave examples for the 1st two entries. Attached worksheet. Thanks & Regards Anupam ShrivastavaSolved199Views0likes5CommentsExcel 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.83Views0likes2CommentsChart 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.572Views1like8CommentsFormat 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 NigelSolved190Views1like4Comments