Keep series hidden on update in PPT chart
D
Developed Echidna
User adjusts her PPT chart after exporting her table, to only show the top 10 rows (she wants to show all rows in her table because she exports all rows to excel). User wants to keep this modification on updating the PPT chart, but the new exporter resets it to plot all rows again so she is stuck using the legacy exporter.
Open the QPack and PPT file (which was exported using the new exporter).
Right click the chart and select
Edit Data
.Drag the shaded area so that the top 5 categories are plotted:
!image-20220722-214514.png|width=1858,height=789!
Save the PPT file.
Update the ppt file from Q using the new exporter, you’ll see all the categories are plotted:
!image-20220722-214609.png|width=1919,height=749!
If you do the above but use the legacy exporter to initially export and update, only the top 5 will remain.
!image-20220722-214822.png|width=1616,height=759!
This goes back to the them wanting to use the same tables to export to excel and show data and also tweak in their report. Especially useful where data might update and there might be a new top X order.
[^PPT export top 5 example.QPack]
[^example top 5.pptx]
J
Jamie Morris
Merged in a post:
Retain Edit data range on export to PowerPoint
L
Lemon Dragon
The user wants to retain the Edit data range on export from Displayr to PowerPoint. The key with exporting with the new exporter is to only export the data that you want to show in the chart. Previously the data was "updated" by a mechanism more like a copy and paste, but the updating of the charts now actually updates assuming all data is going to be shown in the chart.