When I create a chart I set the horizontal axis lables by highlighting the column headers from my data sheet. My graph is made from a single row of data anywhere from 1 to 52 lines below these column headers.

Everytime I select new data my axis lables disappear but I want to keep them, as my data will ALWAYS refer to these column headings.

I have used a different graph that was set up by an absent colleague, and the axis lables never change when I select new data but I'm damned if I can find out how she did it (no she has not written in text boxes over the top).

Help!