# Convert Perspective XY Chart to Report Component XY Chart? **URL:** \ **Category:** Ignition\ **Tags:** perspective, ignition81\ **Created:** [February 7, 2025, 8:47pm UTC](https://forum.inductiveautomation.com/t/convert-perspective-xy-chart-to-report-component-xy-chart/102056 "2025-02-07T20:47:30Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\ **Post date:** [February 7, 2025, 8:47pm UTC](https://forum.inductiveautomation.com/t/convert-perspective-xy-chart-to-report-component-xy-chart/102056/1 "2025-02-07T20:47:30Z")
I have developed several interfaces in our MES that have an "Export to Excel" button that takes Table data and turns it into Excel. I now have some XY Charts that I would like to offer a similar "Export to PDF" feature for. I know this could be done via the Report Component XY Chart, but it looks very different programmatically from the Perspective XY Chart. It took me a while to learn the format of the Perspective version, and before I delve into understanding the format of the Report Component version I figured I should ask if anyone might have some pointers on how to go about it... ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 7, 2025, 8:59pm UTC](https://forum.inductiveautomation.com/t/convert-perspective-xy-chart-to-report-component-xy-chart/102056/2 "2025-02-07T20:59:41Z")
Teach yourself with Vision's Classic Chart, so you can see results near-instantly. The reporting module uses JFreeChart just like Vision. ---
**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\ **Post date:** [February 7, 2025, 11:22pm UTC](https://forum.inductiveautomation.com/t/convert-perspective-xy-chart-to-report-component-xy-chart/102056/3 "2025-02-07T23:22:56Z")
I have it mostly figured out, except for how to get the bars not to overlap. I'm trying to recreate: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/3/33978974d8b679e1fb85d27a2a208833c52eeb46.jpeg) ...but it looks like: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/c/cc54c296982fe8252793e283c8b85cf4f63b1ea8.png) Is this possible, or I do have to use lines instead of bars? ---
**Author:** ![Farhan\_Basheer](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/farhan_basheer/32/66759_2.png) [@Farhan\_Basheer](https://forum.inductiveautomation.com/u/Farhan_Basheer)\ **Post date:** [May 23, 2026, 12:32pm UTC](https://forum.inductiveautomation.com/t/convert-perspective-xy-chart-to-report-component-xy-chart/102056/4 "2026-05-23T12:32:37Z")
How did you managed to Export the chart to the Excel sheet? Could you please share some Insights? Thank you. ---
**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\ **Post date:** [May 26, 2026, 1:37pm UTC](https://forum.inductiveautomation.com/t/convert-perspective-xy-chart-to-report-component-xy-chart/102056/5 "2026-05-26T13:37:14Z")
> **[system.dataset.toExcel | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-dataset/system-dataset-toExcel)** > > Formats the contents of one or more datasets as an Excel spreadsheet, returning the results as a byte array. ...followed by... > **[system.perspective.download | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/scripting-functions/system-perspective/system-perspective-download)** > > Downloads data from the Gateway to a device running a Session.