Sept. 16, 2022, 8:38 a.m.
Reading tracker using excel with pie chart and bar graph for visualisation. This dashboard is created using pivot, advance excel functions and macros.
Reading tracker using excel with pie chart and bar graph for visualisation. This dashboard is created using pivot, advance excel functions and macros.
Fucntions:
1. COUNTIF: Count the number of values present in a specified range with matching condition.
=COUNTIF(Table1[Read],"Read")2. COUNTA: Count the number of values in a specified range.
=COUNTA(Table1[Title])3. SUMIF: Sum of range with matching condition.
=SUMIF(Table1[Read],"Read",Table1[Price])4. XLOOKUP: The XLOOKUP function searches a range or an array, and then returns the item corresponding to the first match it finds.
=XLOOKUP("Reading",Table1[[#All],[Read]],Table1[[#All],[Title]])Macros is used for refreshing the dashboard.