One of the issues with formatting charts in Excel is that there are so many menus ... If the area you have selected contains text, you'll see a second drop-down menu in the Format Chart Pane ...