Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly... Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly

Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly... Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly

Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly... Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly

Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly... Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly

## How To Create A Boxplot In Excel

## How To Create A Boxplot In Excel

### Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly

- Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly
- Unfortunately, handling negative values in boxplots is a challenge using Excel VBA (which is the programming language used to create the Real Statistics Resource Pack). As a result, I had to use a trick: e.g. if the smallest negative number among the data is say -10, then I added 10 to all the data elements; in this way there are no negative values. The result is that the boxplot looks exactly

### You can find us here:

- Australian Capital Territory: Stirling ACT, Dubbo ACT, Isaacs ACT, Spence ACT, Mt Crawford ACT, ACT Australia 2642
- New South Wales: Warburn NSW, Woolloomooloo NSW, North Curl Curl NSW, Cambewarra NSW, Gwandalan NSW, NSW Australia 2041
- Northern Territory: Sadadeen NT, Adelaide River NT, Milikapiti NT, Desert Springs NT, Yulara NT, Moulden NT, NT Australia 0826
- Queensland: Holmview QLD, El Arish QLD, Moreton Island QLD, Cowan Cowan QLD, QLD Australia 4085
- South Australia: Lake Frome SA, Inverbrackie SA, Snowtown SA, Shea-oak Log SA, Middleback Range SA, Ironbank SA, SA Australia 5041
- Tasmania: Sheffield TAS, West Moonah TAS, Oonah TAS, TAS Australia 7066
- Victoria: Dixons Creek VIC, Maribyrnong VIC, Glenloth VIC, Merrimu VIC, Barrys Reef VIC, VIC Australia 3001
- Western Australia: Yandeyarra Community WA, South Bodallin WA, Wagin WA, WA Australia 6058
- British Columbia: New Westminster BC, Chase BC, Williams Lake BC, Prince George BC, Fort St. John BC, BC Canada, V8W 3W9
- Yukon: Little River YT, Brewer Creek YT, Clear Creek YT, Sixtymile YT, Thistle Creek YT, YT Canada, Y1A 7C6
- Alberta: Thorsby AB, Spirit River AB, Stavely AB, Legal AB, Manning AB, Edmonton AB, AB Canada, T5K 6J5
- Northwest Territories: Reliance NT, Tuktoyaktuk NT, Inuvik NT, Inuvik NT, NT Canada, X1A 3L7
- Saskatchewan: Plenty SK, Glen Ewen SK, Eston SK, Central Butte SK, Archerwill SK, Aylsham SK, SK Canada, S4P 4C7
- Manitoba: Thompson MB, Swan River MB, Manitou MB, MB Canada, R3B 2P4
- Quebec: Lawrenceville QC, North Hatley QC, Farnham QC, Coaticook QC, Saint-Marc-des-Carrieres QC, QC Canada, H2Y 1W3
- New Brunswick: Sainte-Marie-Saint-Raphael NB, Cap-Pele NB, Paquetville NB, NB Canada, E3B 5H2
- Nova Scotia: Lunenburg NS, Canso NS, Sydney Mines NS, NS Canada, B3J 9S5
- Prince Edward Island: Souris PE, Murray River PE, St. Felix PE, PE Canada, C1A 8N1
- Newfoundland and Labrador: Little Bay East NL, St. Shott's NL, Cape St. George NL, Roddickton-Bide Arm NL, NL Canada, A1B 5J8
- Ontario: Oxford Mills ON, Wallbridge ON, Zion, Kawartha Lakes ON, Turbine, Dinner Point Depot ON, Laggan ON, Georgian Highlands ON, ON Canada, M7A 6L9
- Nunavut: Cape Dorset NU, Clyde River NU, NU Canada, X0A 5H3

- England: Stourbridge ENG, Stourbridge ENG, Rochester ENG, Cheltenham ENG, Paignton ENG, ENG United Kingdom W1U 2A5
- Northern Ireland: Belfast NIR, Derry (Londonderry) NIR, Belfast NIR, Belfast NIR, Derry (Londonderry) NIR, NIR United Kingdom BT2 8H7
- Scotland: Glasgow SCO, Aberdeen SCO, Hamilton SCO, East Kilbride SCO, Kirkcaldy SCO, SCO United Kingdom EH10 7B4
- Wales: Barry WAL, Newport WAL, Newport WAL, Swansea WAL, Barry WAL, WAL United Kingdom CF24 8D2