Excel+5+tips+on

Copy a picture of a chart from another location by holding down Shift and selecting Edit/copy picture

You can have a mixture of charts i.e. columns or lines

Select one of the columns Right‐click it select Chart type and change it to your preference.

Excel by default will not plot any values on a chart where the value is missing

The Chart tab on Tolls/Options allows you to change this Note however this is not a global setting but has to be carried out for each and every chart in the worksheet.

Rectangular 3D blocks column chart is not enforced You can change to cones cylinders pyramids in the Shape tab on the format Series dialog 2D columns and bars do not have to be solid colours

You can have patterned ,textures, gradient etc.

Use the Format Data Series ( Patterns) tab for Fill effects which can give a very pleasing effect.

Excel 5 tips on

A quick way to create a chart is to select the data including the column and row headings and then press F11

Click twice on any segment in a Pie Chart to explode it by grabbing the handles and dragging it away from the other corners.

You can also change the colour by double clicking.

Pie charts are easier to read if you turn off the legend and add labels

Do this in Chart Wizard on ( Step 3) untick show Legend box Tick Category name and value or Percentage box in the Data Labels tab

Pie Chart data labels by default are outside the Pie

You can drag them onto or away from the slices, when dragged away they draw lines leading back to the slice which they have been dragged from.

Error bars can be added to your line graphs illustrating your plus or minus range of the data.

Right click on the line or bar choose Format Data Series from the menu

On the Y Error Bars tab choose Plus or minus or both then set the range to be a fixed value percentage or a standard deviation.