I have a pivot chart that I perfected and I want to use again but change the values from units to dollars. Simply copying the columns of the pivot table and chart together and pasting elsewhere lets me change the pivot table but the chart is not connected. When I choose select data on the copied chart the "Chart data range" is greyed out. Is there a way to do this?
I'm using Excel 2010.
Thanks so much!
I'm using Excel 2010.
Thanks so much!