I have 2 lists that are the same type of data but they are listed 1 below the other and there is a title in between. I need to use the data in column A as the x axis labels but the title gets in the way. How can I 'skip' over that row? I tried just using Ctrl when selecting the data range in the Source Data->Series->Catagory (x) axis labels box but it gives me an error.
Bookmarks