Hello,

I am having trouble adding a secondary axis to a pivot chart. I am currently using excel 10.

Please see the attachment.

Basically I have two things I am trying to calculate: dollar value of upsells and total count of upsells. I want the Primary Y axis to reflect the $ amount of upsells, so this range is from 0 - 5000. I would like the secondary Y axis to reflect the count of upsells, so this range is from about 0 - 50.

You can see how having the data on the same Y axis would render the "count data" useless as there is no way it could be reflected in a 0 - 5000 range.

I want to keep my X axis the same, which shows each warehouse and then further breaks it down to Sum of dollars and total counts. I just want the counts to be reflected on a secondary y axis.

Will someone please help me with this? I am going crazy trying to figure it out. Upsell Data Feb.xlsx