Hello all,
Wanted to start off by saying that this is a great community and I'm glad I've stumbled upon such a valuable resource and only wish I could give back 1% of what I've learned.
To the fun stuff:
I have a pivot chart (bar style) that has a list of employees and the hours that they worked (billable, non-billable, pto, etc). I also have slicers that limit the data to specific department heads, managers, types of employees, and/or if the employee met his/her billable goal.
With 300 employees, the chart has to be quite long (with no limits on the data being presented). However, when we have few results based on the items selected (say: those that report to manager 1 and met their goal = 10 employees, the chart stays the same height and the bars are huge.
Is there any way to have the chart resize based on the number of results. My thought process was to do a counta on the pivot table and use that as a percentage of 300, then take that and multiply it with the original height of my chart with all 300 employees and then macro that to change the height of the chart. So far, no luck.
Any help is greatly appreciated! I also have a simplified file that I could hopefully share some how to help understand my dilemma.
Wanted to start off by saying that this is a great community and I'm glad I've stumbled upon such a valuable resource and only wish I could give back 1% of what I've learned.
To the fun stuff:
I have a pivot chart (bar style) that has a list of employees and the hours that they worked (billable, non-billable, pto, etc). I also have slicers that limit the data to specific department heads, managers, types of employees, and/or if the employee met his/her billable goal.
With 300 employees, the chart has to be quite long (with no limits on the data being presented). However, when we have few results based on the items selected (say: those that report to manager 1 and met their goal = 10 employees, the chart stays the same height and the bars are huge.
Is there any way to have the chart resize based on the number of results. My thought process was to do a counta on the pivot table and use that as a percentage of 300, then take that and multiply it with the original height of my chart with all 300 employees and then macro that to change the height of the chart. So far, no luck.
Any help is greatly appreciated! I also have a simplified file that I could hopefully share some how to help understand my dilemma.