microsoft excel training company borough high street london - charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training company borough high street london - Charts

microsoft excel training company borough high street london - Charts

resolvedResolved · Low Priority · Version Standard

Sarah has attended:
Excel Intermediate course

Charts

How do I change the colours of the legend?

RE: 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,


 

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:

=IsText (A1)

where A1 is the first cell in the range.
6. Click OK.

View all Excel hints and tips


Server loaded in 0.1 secs.