Having a Pivot Graph Show Variances of figures from month to month including percentage and dollar amount as well as the year before

[johnsboxftm]

Hi,

I'm sure it's probably a simple response but I just can't figure it out. I have tried watching videos, reading forums asking coworkers but I want a pivot graph that can:

Take a range of numbers (sales, taxes, delinquents invoices etc) for each month
Have each month at the bottom of the graph
Have the 0-$1,000,000 on the left side of the graph
Have the percentage difference and dollar amount difference show underneath, next to or whatever to each month at the bottom
And then also $ and % variance from the previous year

Thank you.

 

[awoohaw]

@johnsboxftm , welcome to the forum. Can you post a sample of your data using the xl2bb add in (link below). If not at least in a table?