training+excel+microsoft - charts graphs

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training+excel+microsoft - Charts & graphs

training+excel+microsoft - Charts & graphs

resolvedResolved · Low Priority · Version Standard

Elaine has attended:
Excel Intermediate course
Excel Advanced course

Charts & graphs

how do i get colours onto graphs ?

RE: charts & graphs

Hi Elaine

Thank you for your question.

To colour a part of your chart (bars, pie sections lines) select the bar/pie section/line and then right-click on it and select Format Data Series from the menu.

You will then be able to change the colour on the Patterns tab.

To change the colour of the chart background, select the Plot Area, then right click and select Format Plot Area. Change the background colour on the Patterns tab.

I hope this helps.
Amanda


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.08 secs.