Graphical Techniques

GraphicalTechniquesInstructions365.xlsx

Home >Business & Finance homework help >Graphical Techniques

Data

Graphic Tutorials	These instructions have been updated for MS Excel 365
Data	Rank	UK Shopping Centre	Region	Area (m2)	2018 Annual Visitors (mil)	% by Area
1	Westfield London	Greater London	235,900	27.5	13.5
2	intu Metrocentre	North East England	192,900	21	11
3	intu Trafford Centre	North West England	188,000	31	10.8
4	Westfield Stratford City	Greater London	184,100	49.5	10.5
5	Bluewater	South East England	169,200	28	9.7
6	Bullring Estate[a]	West Midlands	163,000	36.9	9.3
7	Manchester Arndale	North West England	155,200	42	8.9
8	intu Merry Hill	West Midlands	155,200	18	8.9
9	Liverpool One	North West England	154,000	26	8.8
10	intu Lakeside	South East England	149,800	20	8.6
Total Area	1,747,300	100
Reference
Wikipedia. (2020, 4 August, at 23:57 UTC). List of shopping centres in the United Kingdom by size. https://en.wikipedia.org/wiki/List_of_shopping_centres_in_the_United_Kingdom_by_size
UK Shopping Centre	Fictitious Data	Fictitious Data
Data	Westfield London
Month	2018 Visitors (mil)	Quarter	Westfield London	Metrocentre	Trafford Centre
1	2.0	Q1	6.8	5.0	7.6
2	2.3	Q2	8.3	6.5	6.3
3	2.5	Q3	7.2	4.3	9.8
4	2.5	Q4	5.2	5.2	7.3
5	3.6
6	2.2	27.5	21.0	31.0
7	2.6
8	1.9
9	2.7
10	1.7
11	2.3
12	1.2
27.5

Bar Chart

Bar Chart
This will normally display one qualitative variable in terms of frequency
Data	UK Shopping Centre	Area (m2)	Step 1	Select both columns
Westfield London	235,900
intu Metrocentre	192,900
intu Trafford Centre	188,000
Westfield Stratford City	184,100
Bluewater	169,200
Bullring Estate[a]	163,000
Manchester Arndale	155,200
intu Merry Hill	155,200
Liverpool One	154,000
intu Lakeside	149,800
Step 2	Insert 2D Column or 2D Bar Chart
Either vertical or horizontal columns create a bar chart
Step 3	Add the Axis Titles. The Chart Title is optional for this assignment.
We can see that the horizontal bar chart categories are easier to read.
a. Deleted Chart Title
b. Click on Chart border
c. Click on Chart Design (top menu)
d. Click on Add Char Element
e. Click Axis Titles
f. Primary Horizontal
Type Area m2
g. Primary Horizontal
Type UK Shopping Centre
Things to know
The axis values begin at zero.

Area (m2) Westfield London intu Metrocentre intu Trafford Centre Westfield Stratford City Bluewater Bullring Estate[a] Manchester Arndale intu Merry Hill Liverpool One intu Lakeside 235900 192900 188000 184100 169200 163000 155200 155200 154000 149800

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

UK Shopping Centre

Area m2

Stacked Bar Chart

Stacked Bar Chart
This will display more than one qualitative variable in terms of frequency	Fictitious Data
Data	UK Shopping Centre	Quarter	Westfield London	Metrocentre	Trafford Centre	Step 1	Select right three columns
Q1	6.8	5.0	7.6
Q2	8.3	6.5	6.3
Q3	7.2	4.3	9.8
Q4	5.2	5.2	7.3
27.5	21.0	31.0
Step 2	Insert 2D Column or 2D Bar Chart
Step 3	Add the Axis Titles. The Chart Title is optional for this assignment.
We can see that the horizontal bar chart categories are easier to read.
a. Deleted Chart Title
b. Click on Chart border
c. Click on Chart Design (top menu)
d. Click on Add Char Element
e. Click Axis Titles
f. Primary Horizontal
Type Quarter (2028)
g. Primary Horizontal
Type Visitors (Millions)
h. Add column labels
Need to replace the 1, 2, 3, 4
Click on Chart border
Click on Chart Design (top menu)
Click on Select Data
Click on Edit
Select the first column (Quarter)
OK, OK
Things to know
The axis values begin at zero.

Westfield London 6.8 8.3000000000000007 7.2 5.2 Metrocentre 5 6.5 4.3 5.2 Trafford Centre 7.6 6.3 9.8000000000000007 7.3

Quarter (2018)

Visitors (Millions)