Dynamic chart in MS Excel using Pivot Table

85 views · Published 22 September 2018 · 7:47 · Indexed 11 October 2026

Channel: Krishna S · 2018 · Science & Technology

Watch on YouTube

Using pivot table it is easy to create a dynamic chart. It give an option manipulate the chart as we want. Provides an Option to select single or multiple options. And the chart area automatically adjusts based on the selected items. Based on the number of items select the chart will shrink or grow to fit inside the predefined chart area. It only works in office 2016

Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: krishtalk.com
Google Plus: https://plus.google.com/+KrishSanj/
Twitter @iTwittt
https://twitter.com/iTwittt

More from this channel

• 5:15 How to get a list of files in folder in Excel

  Krishna S

  3,143 views · 30 June 2015

• 7:04 How to delete blank rows in Excel

  Krishna S

  3,455 views · 3 July 2015

• 7:38 How to create macro in Personal workbook

  Krishna S

  342 views · 16 August 2015

• 5:43 Copy of How to create your own Excel Add-in - Currency converter - number to text

  Krishna S

  113 views · 13 October 2015

• 3:03 How to format MS Excel cell comments

  Krishna S

  142 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 2

  Krishna S

  4,514 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 3

  Krishna S

  2,645 views · 20 November 2015

• 7:25 Excel cell referencing RELATIVE ABSOLUTE and MIXED

  Krishna S

  1,068 views · 14 January 2016