Download - Advanced Excel Charting.xlsx
-
7/25/2019 Advanced Excel Charting.xlsx
1/19
Progress OUTER LABELS DialPies Numerical Values
56 30 Very Low 10
30 Low ! 0
60 "e#ium 1 10
30 $i%& 1 '0
30 Very $i%& 1 3010 56( Pro%ress 1 )0
1 50
1 60
1 *0
1 0
1 !0
! 100
-
7/25/2019 Advanced Excel Charting.xlsx
2/19
+NNER
3',6
3',6
3',6
10
*','10
-
7/25/2019 Advanced Excel Charting.xlsx
3/19
Da-eSales
Ba.%/o/ New or/ &ica%o Lo.#o. Berli.
2a.1' *,1!163 0 0 0 0 0
4e1' '!,635) 0 0 0 0 1
"ar1' 3),06)5 0 0 0 0 '
Ar1' 1,*!!* 0 0 0 0 3"ay1' 1,!31! 0 0 0 0 )
2u.1' '6,6*3 0 0 0 0 5
2ul1' ,!*)6 0 0 0 0 6
Au%1' 150,)33 0 0 0 0 *
Se1' 1)6,05 0 0 0 0
Oc-1' 1*!,51) 0 0 0 0 !
No71' 53,*55 0 0 0 0 10
Dec1' 1!',56 0 0 0 0 11
2a.13 ''3,)!' 0 0 0 0 1'
4e13 ')5,'3! 0 0 0 0 13"ar13 ''',6! 0 0 0 0 1)
Ar13 1*,)!) 0 0 0 0 15
"ay13 )'5,366 0 0 0 0 16
2u.13 36',!6) 0 0 0 0 1*
2ul13 10',156 0 0 0 0 1
Au%13 3'5,33 0 0 0 0 1!
Se13 )5*,15 0 0 0 0 '0
Oc-13 63*,*16 0 0 0 0 '1
No713 13',3) 0 0 0 0 ''
Dec13 35!,55) 0 0 0 0 '32a.1) 1,313 0 0 0 0 ')
4e1) 6),!5! 0 0 0 0 '5
"ar1) ',5166 0 0 0 0 '6
Ar1) 10'*,) 0 0 0 0 '*
"ay1) )'1,3) 0 0 0 0 '
2u.1) 661,151 0 0 0 0 '!
2ul1) 333,063 0 0 0 0 30
Au%1) )3*,!)) 0 0 0 0 31
Se1) )6,*0* 0 0 0 0 3'
Oc-1) 100!,06 0 0 0 0 33
No71) !10,603 0 0 0 0 3)
Dec1) 30!,!5 0 0 0 0 35
2a.15 5),5135 0 0 0 0 36
4e15 1'1),*5 0 0 0 0 3*
"ar15 '*',0 0 0 0 0 3
Ar15 **),163 0 0 0 0 3!
"ay15 11*!,3 0 0 0 0 )0
-
7/25/2019 Advanced Excel Charting.xlsx
4/19
2u.15 56*,)5 0 0 0 0 )1
2ul15 *'),)) 0 0 0 0 )'
Au%15 '6*,)) 0 0 0 0 )3
Se15 )63,!' 0 0 0 0 ))
Oc-15 551,) 0 0 0 0 )5
No715 '*,0'6 0 0 0 0 )6Dec15 !**,3' 0 0 0 0 )*
-
7/25/2019 Advanced Excel Charting.xlsx
5/19
L+STDATE8O44SET9:A:3;VLOO
-
7/25/2019 Advanced Excel Charting.xlsx
6/19
-
7/25/2019 Advanced Excel Charting.xlsx
7/19
TA9ALLDATE=VLOO
-
7/25/2019 Advanced Excel Charting.xlsx
8/19
-
7/25/2019 Advanced Excel Charting.xlsx
9/19
PARAMETERS:
Demand Function:P=a-bQ P = 99 - 6Q
Supply Function P=c+dQ P = 25 + 14Q
a= 99b= 6
c= 25
d= 14
EQUILIBRIUM
Consumer Producer
Price 76.8 76.8
Quantity 3.7 3.7
VALUES
Q Demand Supply
0 99.000 25.000
3.7 76.800 76.800
8 51.000 137.000
EXTRAS
Q P*
0 76.83.7 76.8
Q BaseCS CS
0 76.800 22.20
3.7 76.800 0.00
Q BasePS PS
0 25.000 51.800
3.7 76.800 0.000
CS 41.07
PS 95.83 1
0 0.1 0.2 0.3
0
20
40
60
80
100
120
Equilibrium in
0
0
20
40
60
80
100
120
140
160
-
7/25/2019 Advanced Excel Charting.xlsx
10/19
0.4 0.5 0.6 0.7 0.8 0.9 1
Perfectly Competitive !r"et
3.7
-
7/25/2019 Advanced Excel Charting.xlsx
11/19
Product Inventory Cost PriceWord 120 90 150
Excel 60 100 150
Powerpoint 75 85 150
Access 40 80 110
Onenote 50 105 110
PowerBI 50 60 90
-
7/25/2019 Advanced Excel Charting.xlsx
12/19
-
7/25/2019 Advanced Excel Charting.xlsx
13/19
A B
forma
'01330 60 60
!0 60 60
'01)60 !0 1'0
60 30 0
'01550 '0 100
*0 100 '0
ellSie '5
5 10 15 '0 '5 30 35 )0
'013
60 '5 '5 '5 '5 1'0 0 0
60 '5 '5 '5 '5 0 '5 '5
60 *0 *0 *0 *0 0 !5 !5
'01)
60 '5 '5 '5 '5 1'0 '5 '5
60 '5 '5 '5 '5 0 '5 '5
60 *0 *0 *0 *0 0 *0 *0
'015
60 '5 '5 '5 '5 1'0 '5 '5
60 '5 '5 '5 '5 0 '5 '560 !5 *0 *0 *0 0 *0 *0
11#
11#
11#
11#
11#
11#
11#
11#
11#
-
7/25/2019 Advanced Excel Charting.xlsx
14/19
)5 50 55 60 65 *0 *5 0 5
0 0 0 1'0 0 0 0 0 0
'5 '5 '5 0 0 0 0 0 0
!5 !5 !5 0 1'0 1'0 1'0 1'0 1'0
'5 '5 '5 1'0 0 0 0 0 0
'5 '5 '5 0 '5 '5 '5 '5 '5
*0 *0 *0 0 !5 !5 !5 !5 !5
'5 0 0 1'0 0 0 0 0 0
'5 '5 '5 0 0 0 0 0 0*0 !5 !5 0 1'0 1'0 1'0 1'0 1'0
-
7/25/2019 Advanced Excel Charting.xlsx
15/19
!0 !5 100 105
1'0 0 0 1'0
0 0 0 0
0 1'0 1'0 0
1'0 0 0 1'0
0 '5 '5 '5
0 !5 !5 0
1'0 0 0 1'0
0 0 0 00 1'0 1'0 0
75#
25#
1 2 3 4 5 6
-
7/25/2019 Advanced Excel Charting.xlsx
16/19
DATESALESINDE MAGNIFY SHOWBOO NUMBER STARTPERIOD
21' T$B 0 1 D1'
41' T$B 0 '
"1' T$B 0 3 MAGNIFYSCOPE
A1' T$B 0 ) MAGNIFYLABEL
"1' T$B 0 521' T$B 0 6
21' T$B 0 *
A1' T$B 0
S1' T$B 0 !
O1' T$B 0 10
N1' T$B 0 11
D1' 1 1'
213 1 13
413 1 1)
"13 1 15A13 1 16
"13 1 1*
213 1 1
213 1 1!
A13 1 '0
S13 1 '1
O13 1 ''
N13 1 '3
D13 1 ')
21) 1 '541) 1 '6
"1) T$B 0 '*
A1) T$B 0 '
"1) T$B 0 '! STARTPERIOD
21) T$B 0 30
21) T$B 0 31
A1) T$B 0 3'
S1) T$B 0 33
O1) T$B 0 3)
N1) T$B 0 35
D1) T$B 0 36
215 T$B 0 3*
415 T$B 0 3
"15 T$B 0 3!
A15 T$B 0 )0
"15 T$B 0 )1
215 T$B 0 )'
0
50
100
150
200
250
300
350
-
7/25/2019 Advanced Excel Charting.xlsx
17/19
215 T$B 0 )3
A15 T$B 0 ))
S15 T$B 0 )5
O15 T$B 0 )6
N15 T$B 0 )*
D15 T$B 0 )
-
7/25/2019 Advanced Excel Charting.xlsx
18/19
STARTOFFSET NUMBEROFPERIOD
1' 15
8O44SET9::1;STARTO44SET;0;NU"BERPER+OD;1=
8O44SET9:A:1;STARTO44SET;0;NU"BERPER+OD;1=
Decemer!"#$" UMBER OF PERIODS $&
-
7/25/2019 Advanced Excel Charting.xlsx
19/19