Hi, how can I create a dynamic gauge chart in pivot table. the data of the pivot table comes from the master list sheet as per attached excel. please advise! Thanks, Abdul