# How would I implement a loading icon for a bar chart running a sql statement **URL:** \ **Category:** Ignition\ **Created:** [September 5, 2017, 1:27pm UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249 "2017-09-05T13:27:07Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jbb5310](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Post date:** [September 5, 2017, 1:27pm UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/1 "2017-09-05T13:27:07Z")
I understand that there is a loadingproperties for the easy chart which is great but I would like to know if there is one for the different graphs. I am using a bar graph to visually depict the number of alarms per day from the previous month and it take a while to load the data. I would like an indicator to let the user know that the data is being loaded. ---
**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 5, 2017, 6:24pm UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/2 "2017-09-05T18:24:14Z")
This may help you out: > [@\[BYES Apps\] Busy Label HMI components (Ignition 7.8.3+)](http://forum.inductiveautomation.com/t/byes-apps-busy-label-hmi-components-ignition-7-8-3/6587): > > A Busy Label HMI components [image] Simply drop in the designer Adjust size and color Set busy properties ON or OFF. 7.8.0 to 7.8.2 [HmiComponents-signed-1.0.0.modl](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/94651c131922f1c907e19bb76ff2f271cfed7050.modl) (370 KB) ---
**Author:** ![rrdiggy76](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rrdiggy76/32/3741_2.png) [@rrdiggy76](https://forum.inductiveautomation.com/u/rrdiggy76)\ **Post date:** [September 5, 2017, 9:45pm UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/3 "2017-09-05T21:45:53Z")
I’ve seen this done by our developer - 1. Use a ‘Progress Bar’ available from the Display components 2. Set the ‘Indeterminate’ Behaviour property attribute of the progress bar to TRUE 3. Set the ‘Visible’ property attribute as a property binding to the ‘Properties Loading’ Property of the chart that contains the data The bar will appear and scroll side to side until the data is loaded and then disappear. We do this to show data loading from an sql query if the query is slow to update on the screen, the user knows something is in progress ---
**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Post date:** [September 6, 2017, 5:20am UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/4 "2017-09-06T05:20:09Z")
You could also try this template. Essentially, load any animated gif into the Image Manager, and set the imagePath property to match. Boom, animated gifs. [Animated Gif\_2017-09-05\_2317.proj](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/dbf635959263b67e846b8ab071eb63070c5b3d68.proj) (5.9 KB) ---
**Author:** ![jbb5310](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Post date:** [September 6, 2017, 11:38am UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/5 "2017-09-06T11:38:16Z")
doesn’t allow me to drop onto the designer "Unknown file type cannot import " Would it have to do with the version of ignition I am running 7.9.3 ---
**Author:** ![jbb5310](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Post date:** [September 6, 2017, 11:44am UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/6 "2017-09-06T11:44:43Z")
Thanks for the step by step but not all charts have that loading property you speak of, for example the one I am currently using the bar chart does not as well as a few others. ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e1c50b614e8b6e31dbe29a423f845653f56344ec.png) ---
**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 6, 2017, 1:32pm UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/7 "2017-09-06T13:32:01Z")
> [@jbb5310](#): > > doesn't allow me to drop onto the designer "Unknown file type cannot import " Would it have to do with the version of ignition I am running 7.9.3 This is a module that is loaded into the gateway. ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4c3df896c9aca72d2be24ac430cf58c2075e4061.png) ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c0217ef6afadb43c3345ee297883dcff1fef7efa.png) ---
**Author:** ![rrdiggy76](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rrdiggy76/32/3741_2.png) [@rrdiggy76](https://forum.inductiveautomation.com/u/rrdiggy76)\ **Post date:** [September 6, 2017, 2:44pm UTC](https://forum.inductiveautomation.com/t/how-would-i-implement-a-loading-icon-for-a-bar-chart-running-a-sql-statement/15249/8 "2017-09-06T14:44:00Z")
Could you not just create a power table and create the same data that’s in your bar chart, then just point your bar chart’s DATA attribute to the Power Table’s Data Dataset? Drive the Progress bar on the Properties loading attribute of the table and make the table invisible. When the Power Table is loaded, the chart must be too? Not the cleanest way, but a work around… ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/fa3259d0a92aa413c44b27268f4025c78bd47849.PNG)