Using powershell to play with pivot table/chart RRS feed

  • Question

  • Is there any way I can use powershell to automate to change the

    1. data range of a pivot table?

    2. data Source of the chart ?

    Thursday, October 9, 2014 8:24 AM

All replies

  • I found my powershell 3.0 missing the method "setsourcedata" for chart object..

    while pivot table I can do that with : $pivottable.sourcedata='thedatarange'

    Friday, October 10, 2014 2:17 AM