Forum Discussion
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.
Thanks, I found the answer here:
https://learn.microsoft.com/en-us/answers/questions/5904872/excel-2024-how-to-add-a-new-month-to-the-existing
2 Replies
Try this:
highlight those 4 new cells and COPY
click on the chart then under Home-Clipboard select the drop drown for PASTE and select PASTE SPECIAL
Then select New Series, Rows and Series Names in First Column (like shown in the image above)
Thanks, I found the answer here:
https://learn.microsoft.com/en-us/answers/questions/5904872/excel-2024-how-to-add-a-new-month-to-the-existing
