Appendix A. List of Sample Files

No.

Filename

169 Charts

100 dynamized by using F9 (simulates the reading of new data)

22 dynamized by using controls

8 contain conditional formatting

01

0101_BasicSamples.xlsx

3

3

  

02

0102_PracticeData01.xlsx

1

   

03

0201_Extract.xlsx

3

   

04

0202_Analysis_00.xlsx

0

   

05

0203_Analysis_01.xlsx

1

 

1

 

06

0301_MallCupola.xlsx

1

1

  

07

0302_Limits.xlsx

7

7

  

08

0303_Perception.xlsx

23

22

  

09

0304_Columns.xlsx

5

3

  

10

0305_Bars.xlsx

3

1

  

11

0306_Lines.xlsx

6

5

  

12

0307_Pie.xlsx

5

3

  

13

0308_Scatter.xlsx

4

1

  

14

0309_VariousTypes.xlsx

6

1

  

15

0401_ColorMix.xlsx

0

2

 

2

16

0402_PracticeTemplates.xlsx

7

7

  

17

0403_Ireland.xlsx

4

4

  

18

0404_Stadium.xlsx

2

   

19

0501_Graphics01.xlsx

0

   

20

0502_Graphics02.xlsx

1

1

  

21

0601_Indicators01.xlsx

1

 

1

 

22

0602_BigAndSmall.xlsx ...

Get Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.