Hey Excellers!
Another ExcelPowerTip that shows you step-by-step how to create a combo bar-line Pivot Chart with bars relating to Sales Amount per month and the line relating to overall average across the months.
Both the bars and the horizontal line dynamically adjusts to the selections made on Pivot Chart slicers.
Also I will show how to create a dynamic title on the Pivot Chart which shows the average amount as per slicer filter selections.
Download Excel file with full screenshot instructions from this link:
drive.google.c...
LIKE - SUBSCRIBE - SHARE - COMMENT - ENJOY!
Негізгі бет How to create a Dynamic Horizontal Average Line on Excel Combo Pivot Chart (FREE DASHBOARD DOWNLOAD)
Пікірлер: 2