excel on mac
2710 TopicsUnbelievable mess in Excel files: rows show upside down.
What is happening here? My rows in Excel show upside down (see bellow). Sometimes it disappeared and became normal after scrolling, but this time it stays like you see on the attachment. What can I do? My MacOS is Sequoia 15.7.3 and Microsoft Excel is version 15.28 (16115).Solved40Views0likes2CommentsNeed 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 RedNectarSolved126Views0likes4CommentsMoving 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,79Views0likes3CommentsHi, I need help. I'm creating a calendar, based on events at our farm, which are on different dates.
Each event has its own column, the name of the event is at the top of the column, and the different dates it will occur are listed underneath it. I need to get this event name to automatically appear on an interactive calendar I made in the next sheet. (The calendar shows the date and weekday of a certain month in a certain year, you can change the month and year to whenever you want), I've tried the xlookup functions but I can't seem to get it working. Please help if you can! I'd be happy to take advice.59Views0likes6CommentsNeed help adding calculations to pivot chart
Hi Experts, I have hourly data collected from our shared solar system (14 lots). The feed has three phases and it is the analysis of each phase I'm interested in, in particular I want to plot how each lot within each phase is tracking to a target percentage share as the month progresses. I've started by creating a pivot table with a calculated column giving the running total of the solar power delivered to each lot over the selected period for the selected phase. The problem is, I want to see the running totals as a percentage of the total delivered on any given day for the phase. I've created an illustration to show what I'm trying to achieve - the light green cells are what I'd like to see instead of the running totals given in kWh. The source file can be found on onedrive https://1drv.ms/x/c/c95331b296c5ed04/IQBuIcCgK-boRJGmS1e3EKnLARVxjCZTHEpusuvwckW_dDc?e=tS7i4i Some of the more dedicated followers will probably recognise that this is a follow up question to my recent question that was so skilfully answered in super quick time. I'm hoping I'll be able to create a sheet worthy of sharing with other people who are implementing a shared solar system. [Trivia: I live in NSW Australia, where the government is giving grants to apartment buildings who implement a shared solar system that gives each lot a fair share - where the amount of the allocation is based on the same formula that calculates the strata fees. Larger lots pay more fees and get more solar. My research so far has shown that the sharing system is not quite working as I expected, but I need to make the whole workbook more bulletproof before I share it publicly] TIA RedNectar50Views0likes3CommentsStockHistory Issue #Connect! Error
I built a workbook around the StockHistory function to track the stocks in the S&P 500. I did this a few months ago and I update it once a day. Each stock is presented according to which SPDR Sector the stock resides in. The workbook keeps track of various moving averages, gives me the percentage of stocks by market cap below those various averages. It also computes relative strength for each stock as it compares to the SPDR Sector it is in. Frankly the StockHistory function has been tough to work with and requires a lot of TLC. Refinitiv's data can be pretty hit or miss. A number of the tickers are missing data for a day in the past year or so. It requires a workaround.... no big deal but you would think they would clean the data they distribute so it is correct. I frequently run out of resources but just saving the spreadsheet and reopening usually clears it up. This week I have come across a new error and that is StockHistory returning a #Connect! error. I have spent way too much time looking on the Internet for what is happening and there are only a few posts on various boards that even mention this. One post says that it means the server is busy and try again later. I have done that and it still doesn't work after multiple tries. One other post I read states it is the data provider (I am guessing Refinitiv) throttling the data flow. If so that is very disappointing as more and more users discover this function. I use Office 365 so I pay for the subscription and it is up to date. I use the Excel for Mac version on my desktop, I have the latest OS system and it automatically updates. To be clear, there have been no changes to my spreadsheet and this error just started appearing. I would have thought that if Microsoft has Excel return an error they would have an easy to find explanation of the error and steps to correct it but if it is out there I can't find it. Can anyone help?18KViews0likes22Commentspivot table
In recent versions of Excel 365 for Mac, the drag-and-drop behavior in PivotTables has regressed significantly compared to previous releases. Specifically, when attempting to move a field from the Row or Column area into the Filter area, Excel often interprets the action as a removal rather than a relocation. This breaks the intuitive manipulation of Pivot layouts that has been standard for years. Additional regressions include: Reduced responsiveness of the Field List pane Inconsistent behavior between older PivotTables (created in previous versions) and new ones Hidden or unavailable “Classic PivotTable Layout” options Lack of visual feedback when dragging fields between areas Increased reliance on context menus for basic layout changes Incoherence between Mac and Windows versions of Excel These changes hinder productivity for advanced users who rely on fast, flexible layout adjustments. Suggested improvements: Restore or make optional the classic drag-and-drop behavior Ensure consistent handling of field movements across all areas (Filter, Row, Column, Data) Improve visual cues and drop zones during field manipulation Guarantee parity between Mac and Windows versions Excel’s PivotTable interface used to be a model of intuitive design. Please consider restoring that flexibility — especially for users who build and modify complex reports daily.17Views0likes0Commentsconvert date format
I m struggling to convert some date (mm/dd/yyyy) into the format I want and which other data are (dd/mm/yy). I tried change the format of the whole column into what I want to but nothing changed. I tried other formats too but nothing. PS the data are recognized as date and if I rewrite the date manually it converts into the format I set up. Please bright me upSolved1KViews1like2CommentsLogical test for same text string existing anywhere in both ranges.
Hello. I have a Table of film credits, including the names of directors and writers. Some films have multiple directors (up to 3 individuals), whose names are in columns F, G and H. The writers' names (up to 4 individuals) are in columns J, K, L and M. I want to test for whether the film has a writer/director - e.g, one of the director names in the range F:H is the same as one of the writer names in the range J:M. I have created a column O to contain a formula with a logical test returning Y if there is a writer/director present. I tried =IF(Table4[@[Wri1]:[Wri4]]=[@Dir1]:[Dir3],Y,N) but this returns a spill error. Can anyone help?Solved168Views1like10CommentsHaving Trouble With Macros
Hi! I have been having trouble with my macros. I followed all the steps on enabling them however, when I try to use macro functions on my excel sheets (like changing font colors, adding border, etc) I am unable to do so and my computer adds these arrow keys instead. I am honestly unsure of what to do since I keep exiting and re-entering excel and the same issue persists. If anyone can help that would be great!27Views0likes1Comment