Link Chart with Photo

Hyper link Chart insert employed a student photo  chart add multipleCloumm  chart  single click display

Table student games score student score points add

 Step 1:  [ Note- if use E1 score column No score column No ]

 Step 2 :  Create Table   Select all table $A $ ;CM, if  

Select New table < insert < Line dot Chart (line with marker)< Romove gridline

 Step 3 :  Use Hyperlink

Insert < Shape < Rectangle ( Chart right or left shape )

Score point Button

Score  Shape select table (main table ) score select

Select table B₁ score Cell < Type Name box score

Select table C₁ point Cell < Type Name box point

Chart Button Click ;    Score -Border Click < Right Click < Hyperlink

< Place in this document < Score < Ok

Same  Point ;  Point – Right Click < Hyperlink

<  Place in this document < Point < Ok

Hyperlink chart score point click table score point  cursor move

 Code Set

Alt + f₁₁ < Select Sheet ,< Right Click View code

General change worksheet 

Default code click

< Select change

Sheet range  (“f1”) , Value = Section , Value < Than Close

Chart Scorel Point Click Report Chart Change

Selection Value m

F1  Value Selection Value

Insert Photo

Select all points < Right Click < Format data series < Fill< marker

< Change Colour < Picture (Picture) Increase Picture  size < Marker option < Built in -size – 32, 36 any size

Shape Picture Double click fill picture change