Working with spreadsheets/Charts/Customising a chart

Customising the look of a chart
Having created a chart, Excel provides many options for changing the way it looks.

Let's apply this to our chart from the previous section:

Selecting a non-consecutive range
There are times where we cannot simply click-and-drag a range to use for our chart.

Displaying a chart in its own sheet
Now let's apply what we have learned to the bookshop spreadsheet.

Summary
You have:


 * Chosen data ranges to make a chart
 * Created two different types of chart
 * Customised a chart including colour, layout and titles
 * Moved a chart to its own sheet