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?

Question added by Shanawaz Ahmed , Group Finance Manager , KGT Group
Date Posted: 2015/06/10

Upvote (0) Views (4) Followers (2) Answers (2) Report Question

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

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

that is it

by 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 ... See More

Answers (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> See More

Answers (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 ... See More

Answers (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 ... See More

Answers (4)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.