AugustaExcel
New Member
I emailed this question into Chandoo, but I thought I would post it here as well.
I've got a Basic Data Set that is a Range of Dates and Number of Employees that week. I've summarized it in a Pivot Table and added Slicers and a Basic Line Graph showing the fluctuating employee level over the time period. I'd like to add the Max and Min Data Points to the line graph and have those values change with the data as the slicers and/or filters are applied.
I know this would involve either Error Bars or Drop Lines or adding a another type of chart to the chart.
Let me know if you've got an questions or anything isn't clear.
Any help or advice on this would be greatly appreciated.
I've got a Basic Data Set that is a Range of Dates and Number of Employees that week. I've summarized it in a Pivot Table and added Slicers and a Basic Line Graph showing the fluctuating employee level over the time period. I'd like to add the Max and Min Data Points to the line graph and have those values change with the data as the slicers and/or filters are applied.
I know this would involve either Error Bars or Drop Lines or adding a another type of chart to the chart.
Let me know if you've got an questions or anything isn't clear.
Any help or advice on this would be greatly appreciated.
