XLSX Chart position
-
Hello,
I am attempting to change the position of a chart in Excel, but I'm unsure how to proceed.
I discovered that the chart's position is located at the path xl/drawings/drawing1.xml, and the relevant element is xdr:twoCellAnchor. I tried modifying xdr:from and xdr:to using xlsxMerge or xlsxReplace, but unfortunately, I did not achieve any results.
for example:
{{#xlsxMerge "xl/drawings/drawing1.xml" (replace "xdr:wsDr.xdr:twoCellAnchor.xdr:from.xdr:row" "12" 20)}}
<c t="inlineStr"><is><t>20</t></is></c>
{{/xlsxMerge}}https://playground.jsreport.net/w/TomiDeak/~avzfgwq
image url)Do you have any suggestions for this?