Excel Charts

Using Excel,SQL,Oracle, and other ODBC Compliant Databases
Post Reply
isaac.rutten
Forum User
Forum User
Posts: 3
Joined: Mon Apr 25, 2016 12:15 pm

Excel Charts

Post by isaac.rutten »

New to Noventri and pretty new to VBA programming.I am using excel as my database. I am looking to put together a production board that has a chart/line graph showing the efficiency's of each work center. One idea is to produce the chart in excel, then use a macro to save it as a .png. I could then link the .png to an image region with the excel database. Am I way out in left field with this one or is that possible? The only think I am having trouble with is the macro to save it as a .png.
Any help is much appreciated.
Martin-Noventri

Re: Excel Charts

Post by Martin-Noventri »

Hi isaac.rutten,

Thanks for posting.

With Noventri Suite, there is the ability to create bar graphs that pull data from the database. Feel free to contact us to discuss your needs further.

As for getting the image of the line graph from Excel into Noventri Suite, you could also save the exported image to a drop folder. (See the Image Drop Folder Tutorial at viewtopic.php?f=62&t=477) This will get the image out to the screen without having to open Noventri Suite.

Kind regards,
Martin
Post Reply