Recent Discussions
How to add a new month to the existing bar graph?
Question: How to add a new month to the existing bar chart? I have 3 rows. Oct 2025, April 2026, May 2026 The headings are: Month, Start Value, End Value, Change The bar chart has the 3 start values and then the 3 end values then the 3 change I added a 4th row and the formulas and they change values as they should. The June values are just dummy values. But I do not know how to add the 4th month to the existing bar chart that updates as well. I can create a new one but then I have to re-create the chart details.
Tab header font issue when the "new zoom" feature is enabled
We found a curious font display issue, which can only be reproduced if the "new zoom" feature flag is active: We can reproduce it with build 20026.20076 with the zoom slider visible (e.g. in the "Current Channel (Preview)"), but we cannot reproduce it on the same build with the zoom slider invisible (e.g. on a freshly updated system in the Current Channel, which has not received the staged rollout yet) or with older builds (e.g. the current Monthly Channel build). The problem itself is unrelated to zooming. Repro 1. Create a new Access database. 2. Create a new form in Design View. 3. Add a Tab Control. 4. Set the tab control's "Use Theme" property to "No". 5. Add a button with the following code: Private Sub Command3_Click() Dim start As Double ' Localize the page name, if you use a non-English version of Access Me.Page2.Visible = True ' Simulate long-running operation (3 seconds) start = Timer Do Until Timer > start + 3: Loop End Sub 6. Save and open the form in Form View. 7. Click the button. Expected result: Nothing happens for 3 seconds. Actual result: The tab header's font switches to some old raster system font (MS Sans Serif?). After 3 seconds, the form returns to the 21st century. This issue is easy to work around: just do the long-running operation before setting the Visibility property, this will reduce the font-change to a short flicker. Still, this appears to be an unintended side effect of the changes made for the "new zoom" feature, so I thought it might be helpful to report it while that feature is still being worked on.3 column layout and footnote to appear in the same column bottom of page
Hi, I have a 3 column layout of text. In the third column, I need to insert a footnote. I need the footnote to appear at the bottom of the page but it must be under the third column at the bottom of the page. see below screenshot. I tried several ways to setting the footnote and it still appear on the left hand side (1st column) bottom of the page.
Column formatted as h]:mm:ss defaults to AMPM time upon editing cell
In Excel, I have a list of minutes and seconds as a 'timer for separate tasks' function, but even after formatting the whole column as [h]:mm:ss it is still reading as AMPM time. I also tried formatting the column as h:mm:ss, no change. The minutes and seconds read correctly in the sheet, but when I make a mistake entering the minutes and seconds, and double click on a cell to edit, it reads as an AM/PM. I am on a Mac. Screenshots to show the issue:Cannot change some cells to date format in Excel
A downloaded Bank statement refuses to allow some but not all cells to be converted to date formats. I have tried simply to format them as dates converted text to columns using both fixed width and delimiter options copied the text to notebook in the hope of stripping off hidden characters =DATEVALUE(A1) ->error Simply justifying the numbers right incantations Any thoughts? Thank you
What type of chart please
Hi guys, I am looking some help. Can anyone advise on what type of chart is needed (if at all possible) to present the below set of data exactly in the way I have created the below mockup. I have tried various bar/cluster/waterfalls, etc but I cannot get the data to be in the same axis format as below. Thanks ClarkeAlternative to Pivot Table in Dashboard for better UI Experience
Hi, currently I am using Excel to build a dashboard for asset management, in particular it is used to track how many items remain after someone borrow it for a particular date range. The data comes from MS Form and has been populated into Excel. I have cleaned up and transform the original data using Power Query and the final form of my data to build the dashboard look something like this. I wish the dashboard to be able to show the following part bracket in red, which represent the details of items being borrowed. Currently I am using pivot table as my solution, as you can observe above. Is there any idea or solution to enhance the overall look of the dashboard? Basically, what I want is instead of directly on the Excel grid, can this be turned into draggable table pane?
Recent Blogs
- Earlier this month, we announced Microsoft 365 Copilot federated connectors were coming to Copilot in Excel. Built on the emerging industry standard Model Context Protocol (MCP), federated connectors...May 28, 2026
- Update health in cloud update is now generally available, with clearer insights into update issues.May 27, 2026
