viladomatus
New member
- Joined
- Feb 19, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi all,
I am encountering a repeated issue with chart templates. I take the following steps when creating the template:
I then copy paste the pivot tables, filter them differently and create charts from template.
The issue i encounter is that, after having created the 8th chart, the template starts using the first pivot table (the one i created the template with) as data source. I took the following steps a none of them have worked:
It looks like there's a finite amount of pivot tables from which a template can retrieve information within a workbook.
I attached a document with a maxed out template so you can see what i'm talking about (issue starts happening with the pivot table on sheet "PT" cloumn AW)View attachment Rank Automatization Tryout.xlsx
Any ideas? This has been really frustrating since i have to create a lot more graphs and the only solution is to copy paste the data in the pivot table into normal cells and then create the chart form there.
Thanks a lot,
Max
I am encountering a repeated issue with chart templates. I take the following steps when creating the template:
- Insert Pivot Chart>Format as desired>Save as template
I then copy paste the pivot tables, filter them differently and create charts from template.
The issue i encounter is that, after having created the 8th chart, the template starts using the first pivot table (the one i created the template with) as data source. I took the following steps a none of them have worked:
- Saving the template from a non-pivot chart
- Creating a new template after the 8th chart is created and deleting the old one, in that case the graph uses the info of the 9th chart for all the following charts
It looks like there's a finite amount of pivot tables from which a template can retrieve information within a workbook.
I attached a document with a maxed out template so you can see what i'm talking about (issue starts happening with the pivot table on sheet "PT" cloumn AW)View attachment Rank Automatization Tryout.xlsx
Any ideas? This has been really frustrating since i have to create a lot more graphs and the only solution is to copy paste the data in the pivot table into normal cells and then create the chart form there.
Thanks a lot,
Max