# Exporting from a Power Chart

**URL:** <https://forum.inductiveautomation.com/t/exporting-from-a-power-chart/100944>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 15, 2025, 7:35pm UTC](https://forum.inductiveautomation.com/t/exporting-from-a-power-chart/100944 "2025-01-15T19:35:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gaven\_Trevino](https://avatars.discourse-cdn.com/v4/letter/g/58f4c7/32.png) [@Gaven\_Trevino](https://forum.inductiveautomation.com/u/Gaven_Trevino)\
**Post date:** [January 15, 2025, 7:35pm UTC](https://forum.inductiveautomation.com/t/exporting-from-a-power-chart/100944/1 "2025-01-15T19:35:49Z")

</div>

When I export the historical data from a power chart to an excel sheet the enter path of the tag is displayed and makes the sheet look bad. Is there a way I can change this to only display the last \*\*\*. Also how can I limit the decimals to a lower amount say max .99 .I will post an example of what I mean

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/7/77633e21c168842a3f57f5a658d8d78ae925fdd7.png)

---

<div class="post-metadata">

**Author:** ![Aaron\_Schuleman](https://avatars.discourse-cdn.com/v4/letter/a/ee59a6/32.png) [@Aaron\_Schuleman](https://forum.inductiveautomation.com/u/Aaron_Schuleman)\
**Post date:** [January 27, 2025, 7:50pm UTC](https://forum.inductiveautomation.com/t/exporting-from-a-power-chart/100944/2 "2025-01-27T19:50:38Z")

</div>

I am also looking for this solution. Have you been able to find a solution yet?

---

<div class="post-metadata">

**Author:** ![jiguti](https://avatars.discourse-cdn.com/v4/letter/j/e495f1/32.png) [@jiguti](https://forum.inductiveautomation.com/u/jiguti)\
**Post date:** [January 28, 2025, 11:21am UTC](https://forum.inductiveautomation.com/t/exporting-from-a-power-chart/100944/3 "2025-01-28T11:21:07Z")

</div>

> [@Gaven\_Trevino](#):
>
> When I export the historical data from a power chart to an excel sheet the enter path of the tag is displayed and makes the sheet look bad. Is there a way I can change this to only display the last \*\*\*. Also how can I limit the decimals to a lower amount say max .99 .I will post an example of what I mean

Same problem here. Any solution ???

---

<div class="post-metadata">

**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:** [January 28, 2025, 1:19pm UTC](https://forum.inductiveautomation.com/t/exporting-from-a-power-chart/100944/4 "2025-01-28T13:19:38Z")

</div>

You have to write your own dataset to Excel script using the Apache POI libraries that IA uses internally. Search this forum for apache poi to find many examples.

Your own script can shorten names to meet your specific needs. No generic tool will be able to do that.