ICT, 5th Grade
EDUCATION INSTITUTE OF AR-ROUDLOH LAMONGAN
SDI AR-ROUDLOH LAMONGAN
Komplek Pondok Pesantren Ar-Roudloh Desa Miru
Kec. Sekaran, Kab. Lamongan, Prop. Jawa Timur
Academic Year 2022/2023
Chapter Semester 2
16
Name :………………………….. Learning : Student are able to
Class/ :………………………….. Object Interactive Chart
Number Microsoft excel.
Day/Date :…………………………..
Topic : Interactive Chart
Score :
…………………………………………
Excel Interactive Chart
A chart is not only displayed in the form of pictures or certain symbols. A chart
can be displayed using pictures and at the same time we can write down the percent
value on each chart.
How to create an interactive
chart
There is a sales target of a company in 2023 as following :
Sales target 2023
Realization For Each Region
Month
Palembang Jakarta Surabaya
January 10.000.000 20.000.000 18.000.000
February 15.000.000 21.400.000 17.000.000
March 12.000.000 25.000.000 20.500.000
April 20.500.000 32.000.000 25.000.000
May 18.000.000 25.000.000 22.300.000
June
July
August
September
October
November
Desember
Total
Target
Percentage reached
1. In the total column, add up using the sum function in each city.
2. In the target column, write down the target in Palembang City, the target that
must be achieved by 80.000.000, in the city of Jakarta for 200.000.000 and in
The city of Surabaya is 100.000.000
3. In the Percentage column it is achieved to share the results of the total each city
with
city targets to be achieved. If you have changed the format to percentages.
SDI AR ROUDLOH MIRU SEKARAN LAMONGAN 1|P a g e
ICT, 5th Grade
4. So that it can be written as follows:
Make a graph of the percentage that can be achieved in 3 cities:
1. Selection results percentage in the 3 cities
2. Click insert tab > coloumb button > 3D clustered column > OK. like the
following picture:
3. Click right on the chart area:
Chart Title
150.00%
Chart area
100.00%
50.00%
0.00%
1 2 3
4. Click select data in that option
5. A dialog box will appear as shown below and click the edit menu beside next
to the right.
6. Then the axis label dialog box will appear as shown below. fill in with hover the
mouse pointer over the button to the right of the box
7. Select the 3 cities > OK
8. Then the result is 3 cylindrical charts which previously had the initials 1, 2 and 3
now it has changed to the name of the 3 cities.
Chart Title
128.50%
SDI AR ROUDLOH MIRU SEKARAN LAMONGAN 150.00% 2|P a g e
94.38%
100.00% 61.70%
0.00%
Palembang Jakarta Surabaya
ICT, 5th Grade
9. To display the percent form on each chart you can select a chart layout located
on the design tab.
Let’s
Do!
1. Write down the data as follows:
Realization For Each Region
Month
Lamongan Gresik Tuban Bojonegoro
May 50000 70500 55000 54000
June 15200 25000 18200 19400
July 25600 40300 27000 28500
August 21300 35500 25400 26000
September 85000 120000 92000 95500
October 32000 45300 40000 42300
November 65200 97000 75000 82000
Total
Target 500000 700000 555000 645000
Percentage
reached
2. Create a chart using the stacked pyramid type with a percent value!
3. Save your file the format: ICT_Interactive Chart_2023
SDI AR ROUDLOH MIRU SEKARAN LAMONGAN 3|P a g e
