jueves, 10 de mayo de 2012 20:01I have read "XL2000: Cannot Change PivotChart Source Range" so I am confirmed that I am not doing something wrong. I used to be able to do this in Office 2003 but can no longer do this in Office 2010. Why would you take this function away? We are a company with multiple facilties we go in and out of every month. I used to have a particular graph with a lot of formatting where I setup a custom template. Then every month as the data would change with new facilities I would copy the chart, resource the data and apply the template. This no longer works and as I've read I have to start the graph from scratch every month....this is has more than quadrupled my work time. Is this a bug??? will this be fixed?
Todas las respuestas
viernes, 11 de mayo de 2012 8:26Moderador
Here’s a workaround for you:
We can create the pivot chart in a new worksheet. And set the fields as back up. That is to say, for example, now there is only 10 columns in the worksheet, but there are also some columns named as field1, field2… Then these back up fields cannot be shown in the Pivot Chart by uncheck the field name in Pivot Table. If the next month you want to add some fields in to the sheet, just update the sheet. When insert a Pivot Chart, select the all columns you have named as range to analyze.
In Excel 2010, if you update the value in the range you selected, then press “Refresh All”, the Pivot Chart will be updated.
TechNet Community Support
- Marcado como respuesta Jaynet ZhangMicrosoft Contingent Staff, Moderator lunes, 14 de mayo de 2012 9:28