microsoft excel training company borough high street london - Charts

Hello Sarah, I hope you enjoyed your Excel Intermediate course. Here is the answer to your question: The Legend can be formatted but the colours displayed in the little squares depend on the colours of the data series items.
You can change the data series item colours by double clicking on a data series item and from the format dialog box which appears choose a different colour.
The legend "Box" can be formatted by double clicking when the tool tip Legend appears and you can then make formatting changes using the dialog box that appears. Hope that answers your question. Pete,