Forum Widgets
Latest 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.
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
