Combining Fields in Pivot Chart

[WorldWideWalt]

I am trying to graph the frequency of a series of cap rates but want to also show the average age of properties that have that cap rate. For example, the chart will show there are 3 properties with a 6.5% cap rate, 6 properties with a 6.75% cap rate etc. but I also want to see the average age of properties with a 6.5% cap rate, 6.75% cap rate etc.

Is there any way to do this. I can only get the graph to plot the average ages as a separate series but I want the chart to show simple frequency with the average age as extra context on the x axis