A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Dear Paul Gailiunas,
Welcome to the Microsoft Q&A forum.
Thank you for sharing the attachments. Based on the charts provided, I understand that you are seeing two different chart views in Excel, and the chart appears to automatically change its appearance. I would like to clarify a few points to help identify the cause.
From your screenshots, it seems that the two charts are not displaying the same underlying data or axis configuration. For example:
- The vertical axis scales are different: one chart goes up to 500,000, while the other only goes up to 100,000.
- The data series colors also differ. The original chart shows multiple colors, whereas the thinner chart displays only two, which suggests fewer data series.
- The x‑axis labels are not the same either. One chart shows only “Jan,” while the other includes specific dates such as 22/12, 29/12, and so on.
These differences typically indicate that the chart may not be referencing the same data range, or that the data itself has been modified. To investigate this further, could you please check the Version History of the Excel file to see whether any data or chart ranges were updated by someone else?
Refer article: View or restore version history of a workbook - Microsoft Support
Once you have this information, feel free to share it here and I will be happy to assist you further.
Looking forward to hearing from you.