Bar Chart issue when Month Name Changes on Axis
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?
|