{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Cover page","Bar chart","Column chart","Line chart","Pie chart"],"not_rendered":{"charts":12},"read":"whole","date_system":"1900"}

{"sheet":"Cover page","index":0,"n_rows":13,"n_cols":3,"rows_kept":13}
[]
[]
[]
[]
[]
[]
[null,null,"Use the tabs at the bottom of the sheet to see examples of common chart types, or click the following links:"]
[null,null,"Bar chart"]
[null,null,"Column chart"]
[null,null,"Line chart"]
[null,null,"Pie chart"]
[]
[null,null,"If you are planning a different type of chart, please speak to your Acas contact for guidance."]

{"sheet":"Bar chart","index":1,"n_rows":22,"n_cols":3,"rows_kept":22}
[]
[null,"Example data - numbers"]
[null,"Employees",100]
[null,"Line managers",25]
[null,"Senior managers",15]
[null,"Directors",5]
{"$rows_empty":11}
[null,"Example data - percentages"]
[null,"Employees",{"v":0.6896551724137931,"d":"69%"}]
[null,"Line managers",{"v":0.1724137931034483,"d":"17%"}]
[null,"Senior managers",{"v":0.10344827586206896,"d":"10%"}]
[null,"Directors",{"v":0.034482758620689655,"d":"3%"}]

{"sheet":"Column chart","index":2,"n_rows":45,"n_cols":12,"rows_kept":45}
[]
[null,"Example data - numbers"]
[null,"Employees",100]
[null,"Line managers",25]
[null,"Senior managers",15]
[null,"Directors",5]
{"$rows_empty":11}
[{"$nulls":11},"Note: This chart is sorted from largest to smallest group, instead of by seniority."]
[]
[]
[]
[{"$nulls":4},"Note: This chart is sorted by seniority, instead of largest to smallest group."]
[]
[]
[null,"Example data - percentages"]
[null,"Employees",{"v":0.6896551724137931,"d":"69%"}]
[null,"Line managers",{"v":0.1724137931034483,"d":"17%"}]
[null,"Senior managers",{"v":0.10344827586206896,"d":"10%"}]
[null,"Directors",{"v":0.034482758620689655,"d":"3%"}]
{"$rows_empty":11}
[{"$nulls":11},"Note: This chart is sorted from largest to smallest group, instead of by seniority."]
[]
[]
[]
[{"$nulls":4},"Note: This chart is sorted by seniority, instead of largest to smallest group."]

{"sheet":"Line chart","index":3,"n_rows":38,"n_cols":6,"rows_kept":38}
[]
[null,"Example data - single line"]
[null,null,"Number of survey respondents"]
[null,2018,478]
[null,2019,593]
[null,2020,450]
[null,2021,604]
[null,2022,698]
[null,2023,735]
[null,2024,768]
{"$rows_empty":9}
[null,"Example data - multiple lines"]
[null,null,"Survey recipients","Survey respondents"]
[null,2018,600,478]
[null,2019,608,593]
[null,2020,580,450]
[null,2021,657,604]
[null,2022,721,698]
[null,2023,780,735]
[null,2024,806,768]
{"$rows_empty":8}
[{"$nulls":5},"Note: Data labels on the lower line have been moved below the line to reduce overlap"]
[{"$nulls":5},"Note: Line labels are coloured to match the line; this is optional"]

{"sheet":"Pie chart","index":4,"n_rows":5,"n_cols":3,"rows_kept":5}
[]
[null,"Example data - numbers"]
[null,"Line managers",25]
[null,"Senior managers",15]
[null,"Directors",5]