# Timeseries Chart doesn't work as Bar Chart as normal Bar Chart

**URL:** <https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [September 15, 2020, 5:31am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684 "2020-09-15T05:31:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrush.dahivalkar](https://avatars.discourse-cdn.com/v4/letter/v/dc4da7/32.png) [@vrush.dahivalkar](https://forum.inductiveautomation.com/u/vrush.dahivalkar)\
**Post date:** [September 15, 2020, 5:31am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684/1 "2020-09-15T05:31:16Z")

</div>

V8.0.15

I am generating Production reports and using historical data from SQL and need to show Bar chart.

The client was use to excel charts and they want same looks in new reports.  
Any suggestion how to achive beter look in reports?  
Thanks

Excel report chart:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/f/8f633ea9ce0c86f29ea5feb0528312aa3f330cfa.png)

Ignition Report:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/6/26cb845926e370fdfafb0c4bc3bec191acba5762.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 17, 2020, 8:51am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684/2 "2020-09-17T08:51:39Z")

</div>

Why use the time series instead of the bar chart?

---

<div class="post-metadata">

**Author:** ![vrush.dahivalkar](https://avatars.discourse-cdn.com/v4/letter/v/dc4da7/32.png) [@vrush.dahivalkar](https://forum.inductiveautomation.com/u/vrush.dahivalkar)\
**Post date:** [September 18, 2020, 12:50am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684/3 "2020-09-18T00:50:08Z")

</div>

How can you show the Time on X-Axis? How you show Time where is Domain Key for bar chart?  
And how you will show the ‘target’ as line chart as referance?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 18, 2020, 1:41pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684/4 "2020-09-18T13:41:02Z")

</div>

Example attached, with references to this thread.

> [@Bar chart (report) static line](http://forum.inductiveautomation.com/t/bar-chart-report-static-line/18445/14):
>
> This is working well in my dashboards. On the reports, which is where I first got it working, the reference line shows up in the preview in the report module, but not in the PDF when the report is emailed. Everything else renders in the PDF as expected. Any ideas what’s preventing the line from rendering in the PDF? The code is: from java.awt import BasicStroke from org.jfree.chart.plot import ValueMarker goal = 0.5 s = BasicStroke( 4.0, #width BasicStroke.CAP\_ROUND, #cap BasicStrok…

Sample uses a static dataset as the raw data, a script iterates through the dataset to (in this example) extract the hour/minute. The chart script allows the us to add static lines.

[report\_barchart\_example 2020-09-18.zip](https://forum.inductiveautomation.com/uploads/short-url/c2IM5AM3Yv6FeKuPYKMRamocPNh.zip) (12.9 KB)

 ![2020-09-18_8-29-56](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f38ed6266e5aa7f266e3ad1419e08bcd9902bc96.png)

---

<div class="post-metadata">

**Author:** ![vrush.dahivalkar](https://avatars.discourse-cdn.com/v4/letter/v/dc4da7/32.png) [@vrush.dahivalkar](https://forum.inductiveautomation.com/u/vrush.dahivalkar)\
**Post date:** [September 21, 2020, 1:03am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-doesnt-work-as-bar-chart-as-normal-bar-chart/38684/5 "2020-09-21T01:03:38Z")

</div>

Thank Jordan,

I nedded some example to work with. I will try this code.  
I am not an expert with scripts but I will give a short.