Download Excel File: https://excelisfun.net/files/EMT1881.xlsx
Enny Kraft from YouTube and Hamidi Hamid from LinkedIn provide temporary fixes for the chart & GROUPBY bug brought up in EMT 1880:
When I create a single cell reporting formula with the GROUPBY array function or other single cell dynamic spilled array reporting formula, and then create an Excel Chart from the single cell formula, and then insert a column, the chart looses track of the correct location for the report. The chart breaks and poinst to the incorrect range.
Topics:
1. (00:00) Introduction
2. (00:01) What is the Bug?
3. (00:26) Hamidi Hamid fix
4. (00:46) Enny Kraft from YouTube fix
5. (01:15) Closing
Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese.
Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish.
#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #groupby #pivotby #groupbybug #pivotbybug #chart #excelchart #excelcharts #excelchartbug