Hi..
I have a number of Line Charts that show Sales and Wages related historical data...
For some reason.. some of the Line Charts have got extra (unwanted) Horizontal Category(Axis) Label entries in the "Select Data Source" popup..
These extra (unwanted) Horizontal Category(Axis) Label entries show as being blank but when i press edit they are linked to data..
Basically.. on the attached Workbook.. all Line Charts that are on the 2 History sheets (Catering History and Bar History).. should only show July to June.
The issue is that some have 2 -4 extra Category entries to the right of June.. I just can't seem to get rid of them..
Hopefully someone has encountered this before and can help me..
Bookmarks