Page 78 - Penta Book's ICT Catalogue

Mini chart

Sometimes you just want a graphical representation of your
data inside a chart. To do this, you can use mini charts.

2
To add a mini chart:

> Select the cells you want
your mini chart to be
displayed in. For example, 1
select D3:D10. 1
> On the Insert tab, in the
Sparklines group, click
Line. 2
> In the Create Sparklines
window, in the Data Range 3
box, type
B3:C10. 3 This contains
the data you want to
represent in a graph.
4
> Click OK. 4 DIGITAL TEENS 2 MODULE 5 Computing and ICT . Sample Pages

To modify a mini chart: 2
> Select the cells D3:D10
where the mini chart is. 1
8
> On the Design tab, in GRADE
the Style group, click
Sparkline Color 2 and
click the color you want. 3
1

3

You can also click
Marker Color to color
your markers.

SMART TIP

Always double-check the formulas in your spreadsheet.
A tiny mistake may cause a huge problem! 77
Penta Books