I am trying to determine why the data in my bar chart gets messed up when I change the Axis name from May to May-16. The cell format for all the month names is Date (Mar-01), and in the cell I have entered 3/1/2016, 4/1/2016, 5/1/2016, etc.



Each month I repeat the process of adding a new month and have not encountered an issue until this month.

It is like for some reason the chart has become corrupt or something. Any ideas?

Attached Images

Chart issue.jpg (221.9 KB, 16 views)

I think it would help if you posted your workbook/sheet. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here is the workbook that I am having issues with. Thank you.

Attached Files

Workbook.xlsx (18.3 KB, 10 views)

I replaced the date in H1 with the text string " May" and the change occurred. ( reformatting to "mmmm" did nothing)
So I suspect it has something to do with the fact you used text instead of a date when adding your new column, the changing it to a date
I'm not savvy enough in charting to help you any further.
Sorry

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for attempting to resolve Pecoflyer! I agree that the issue has something to do with how the chart is reading the format.

The issue has to lie within how the chart is interpreting the data as after recreating the chart it displays correctly.

If anyone has any thoughts please let me know.