Jump to content
Sign in to follow this  
DavidFromLafayette

Plotting data from an array as lines

Recommended Posts

DavidFromLafayette

I have an array, part of which is below, of 13 parameters based on time. What I would like to do is have an XY style plot with time running the Y axis and the 13 parameters plotted across the window.

Any suggestions or "quick" ways to do this would be much appreciated.

[0]||||||||||||||

[1]|2013-03-06 21:15:57.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

[2]|2013-03-06 21:15:57.000| NULL| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

[3]|2013-03-09 08:19:46.000| NULL| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

[4]|2013-03-09 08:19:46.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

[5]|2013-03-09 08:19:46.000| NULL| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

[6]|2013-03-09 08:19:46.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

[7]|2013-03-09 08:20:51.000| 0| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL| NULL|

Share this post


Link to post
Share on other sites
water

Might be an overkill: If you have Excel installed you could pass the array to Excel and then use my ExcelChart UDF to plot the values.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
kylomas

David,

Not sure that this is "quick and easy" (whatever that means to you) but thread may help.

Good Luck,

kylomas


Forum Rules         Procedure for posting code

"I like pigs.  Dogs look up to us.  Cats look down on us.  Pigs treat us as equals."

- Sir Winston Churchill

Share this post


Link to post
Share on other sites
DavidFromLafayette

Looking at the GraphGDIPlus option looks like it will work for me, but when I try to put the graph onto the tab I want to show it on it instead seems to be plotting behind the tab control.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×