Forum Widgets
Latest Discussions
Charts getting cut off when printing to PDF
Hello, User is experiencing an issue where when printing or exporting to PDF, their charts are not scaled to fit the page. Simply by opening page layout dialog on print window and closing it again (no changes made) the chart is exported correctly. However, initiating a print/export before this, it is cut off.kadomonyFeb 12, 2025Copper Contributor3.7KViews0likes1CommentRotating label in horizontal stacked bar chart
Hi all, I've created a horizontal stacked bar chart in excel, but the label of the level 1 category is displayed vertically in the diagram. How do I rotate this, so it is displayed horizontally? Thank you in advance! 🙂 KrisKristoffer_Toft_JensenFeb 12, 2025Occasional Reader3Views0likes0CommentsHelp creating a matrix table
Good day wonderful people, I am trying to create a matrix table that shows correlations between types of issues people may be worrying about. The end result is to enable me to bring it into Power BI and utilize the chord visualization diagram to show where certain issues are connected and the strength of those connections. I have an excel sheet with a range (se below). The first column is a unique client ID. As the data may be collected over a period of time, the same client IDs may appear more than once (if they come back to the service provider). The data may include up to a maximum four issues that they are worrying about, and these are in adjacent columns to the client ID. As an example, in the below table, homelessness has low level interconnectivity with 'Priority Debt'; 'Disabled' & 'Mental Health' as they appear as issues alongside with that string; "Mental health" has a strong connection to "Non-Priority Debt" (and of course vice versa) with it occurring each time the other is mentioned. This is what I am aiming to show. Due to the way in which this data is laid out (from a database export), I am struggling to bring it into a matrix table (if that is the best method) and then on into Power BI. I've spent quite a bit of time in the forums, but can't find a way to apply the learning in them to the table output, or the right way to transform the data (via power query or otherwise) to help identify the interconnectivity. If anyone can point me in the right direction to solve this, I would be most grateful! Thank you in advance :-)79Views0likes5CommentsHow to fill a range of Sheet A with data from Sheet B by repeating this action for each value
Hi, I have two sheets A & B. Sheet A has a table where A1:H1 is the header. The range C2:C9 of this table is blank but there is data in the ranges A2:B9 and D2:H9. Sheet B has data in the range A1:A43. I have to fill the range C2:C9 of Sheet A with data from Sheet B by repeating this action for each value in Sheet B.SolvedDan1ExcelUserFeb 12, 2025Copper Contributor76Views0likes9CommentsErreur référence cellule MACRO/VBA
Bonjour à tous, Je travaille actuellement sur un projet de récapitulatif des congés pris par mes salariés. J'ai utilisé des formules et macro pour automatiser mes calculs, cependant, si les "périodes de congés" sont vides, une erreur s'affiche et bloque toutes les autres formules. Le tableau est mit à jour tout au long de l'année et j'ai besoin qu'il soit utilisable sans cette vilaine erreur "#REF!". Pourriez-vous m'aider ? Voici les infos techniques : 2 feuilles : "Contrat Initial" : feuille du tableau "MACRO" : feuille de données, calendriers des jours fériés etc. Formules utilisées : Total des jours hors jours fériés J'ai besoin d'afficher le nombre de jours ouvrables (lundi à samedi) hors jours fériés Calcul des samedis sur la période J'ai besoin d'afficher le nombre de samedis sur la période de congés saisie. Samedi est défini comme le 6ème jour de ma semaine, selon le système européen. Le calendrier J'ai saisi les données des jours fériés sur la feuille "MACRO" sur la plage A12:F22 Merci d'avance de votre aide !SolvedEzjakaFeb 12, 2025Occasional Reader19Views0likes2CommentsSorting dates in Excel from oldest to newest is not working
Hi all, I would like to sort a date series in Excel, formatted as Mon Feb. 10, 2025 08:59 AM, from oldest to newest, but I can’t get it to work. Every week, I have to download a list from a program that uses this date format (see screenshot). I want to sort it in order from oldest to newest, but when I try to do so, the dates get mixed up. Downloaded list: 2. I select the cells and want to order it from old to new, then it gives me this: Does anybody has a solution for this? Thanks so much in advance! ArianneArianneCFeb 12, 2025Copper Contributor70Views0likes5CommentsExcel filters with live and non-live data
Hi, I have created a spreadsheet for our attendance tracking. The spreadsheet contains some live student and attendance data pulled from our MIS, alongside non-live columns containing weekly comments and attendance categories (excellent, at risk, etc.). This non-live data is not held within our MIS so cannot be part of the liva data feed. I need to be able to either filter or sort the data by attendance category. When I try to do this when highlighting the entire dataset, the functions are not available. This, I presume, is because the live and non-live data columns are acting as two separate entities. I can filter the attendance category but this doesn't also sort the live student data (so the attendance category is not related to the student data), or vice versa. I can extract the data as values into a different worksheet then filter, but this is time consuming and needs to be re-extracted each time the data feed is updated. Is there a way to filter from the original live and non-live data together (i.e. I could filter by absence category and this will also filter the live student data in the related rows)? (We do have PowerBi but we need to be able to have this in Excel to add weekly comments relating to attendance). Thank you in advance!CToddFeb 12, 2025Occasional Reader17Views0likes1CommentCELL NAME DISPLAYING
I gave a name to a Cell and the actual "name", in this case (CALL), is displaying inside the cell underneath of what I type. I had try deleting the name I gave and start again but it does the same. I had tried deleting the rows and adding new fresh rows and it does the same. If I delete and add the name to any other cell, this problem does not happen. It's only those cells. The moment I custom the cell name, it shows back again. This problem it's been bugging me for a long while and I can't find any forum or link on how to... How can I hide the name cell? Is there any option for this? Any help will be appreciated it. Thanks in advance!KrislonFeb 12, 2025Occasional Reader31Views0likes2CommentsCell Value Comparison
Hi, Please can someone help me as I am tearing my hair out right now and Copilot AI is obsessed with header rows and no help at all. I have a spreadsheet with a load of numbers on it and various column formatting (general/dates/currency). I have a formula in a column that compares the difference of 2 other columns and returns the value. If either of the cells are empty then no value is displayed. For some reason the formula hates the value £121.80 and returns a negative value and I have no idea why. Here is an example My formula is =IF(OR(AC4="",X4=""),"",AC4-X4) on the selected cell. But you can see there are 5 negative values and are all £121.80 in AC. Please, any advice would be greatly appreciated! Thanks, HCubanPeteFeb 12, 2025Occasional Reader25Views0likes1CommentRepeat list of items for each month in table
Hi all I am looking to have an automatic repeating list of items that repeats based on the amount of months in a table. If however a month is mentioned in the list of items, the item will only repeat for that month only and not all the months in the table. Please see my example spreadsheet with the desired output, which should make it clear. I just need a formula to make this output table. I guess LET would be possible, but can anyone help please? Thank you MattSolvedmatt0020190Feb 12, 2025Brass Contributor125Views0likes12Comments
Resources
Tags
- excel42,189 Topics
- Formulas and Functions24,457 Topics
- Macros and VBA6,350 Topics
- office 3655,935 Topics
- Excel on Mac2,617 Topics
- BI & Data Analysis2,331 Topics
- Excel for web1,878 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,608 Topics