I have amended a worksheet that creates a chart of 6 rolling periods of data. I've deleted period 8 from the left of the worksheet and added period 1 on the right. I want to view periods 9,10, 11,12,13 and 1 as a bar chart. I can't add period 1 to the horizontal axis even though the column containing the data is included in the formula for axis data labels.
Solved by S. U. in 13 mins