microsoft excel course - charts

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Charts

microsoft excel course - Charts

resolvedResolved · Low Priority · Version Standard

Helen has attended:
Excel Introduction course
Excel Intermediate course

Charts

How do you change the colour of a chart series?

RE: Charts

Single click the chart to enter it.
Single click the series you wish to format
Right click, format series
Naviate to Colour tab
Select colour
Click OK.



 

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.06 secs.