Show Percentages of Week Total (not grand total) in Clustered Column Chart
I have survey response data showing responses over bi-week periods. I am trying to create a clustered column chart to show the preferred categories for that specific time period. The data values are showing as a percentage of the grand total and I would like for them to show as a percentage of the bi-week period.
In a matrix I have the option to show values as a percentage of column total, but in the clustered column chart I only have the option to show the values as a percentage of the grand total.
Is there a way that I can do this for the clustered column chart?