How can I link chart (in excel) to a pivot table so that when i analyse data through pivot table then the chart should automatically update?

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Question ajoutée par Shanawaz Ahmed , Group Finance Manager , KGT Group
Date de publication: 2015/06/10

Apprécier (0) Vues (4) Suiveurs (2) Réponses (2) Report Question

par Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

select any cell in the chart > from insert use chart.

that is it

par Atif Tanveer , Decision Support Specialist , Hamilton Health Science

From you PivotTable create a PivotChart

How to create a pivot table in Excel 2013?
Top Answer: Go to insert Pivot Tables Choose Data source Arrange the data the way you want to present it Create pivot ... Voir Plus

Réponses (4)
How important MS Excel - Pivot table feature is for your job as a Project Manager/Manager? Please share..
Top Answer: <p>Its a good way to filter and present available data as a meaningful information</p> Voir Plus

Réponses (12)
What is the importance of pivot table in data analysis?
Top Answer: A pivot table is a data summarization tool found in many data visualization applications that use data fr ... Voir Plus

Réponses (1)
Is it more convenient to use MS Excel Pivot Table to prepare a financial statements?
Top Answer: Pivot Table Since that Microsoft added pivot tables for the first time one of the most attractive and fre ... Voir Plus

Réponses (4)

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?