Jump to content

Report Generation Excel "XY graph" isn't, really


torekp

Recommended Posts

I'd like to make true XY graphs in Excel, where each data series has its own set of X values and Y values.  Unfortunately, interleaving rows of X data, Y data, X data, Y data, etc., won't do it: only the first row counts as X data.  And "updating graph data" as shown in this block diagram, doesn't work like I'd hoped.  That VI should be called "overwrite graph data" not just "update".  Am I overlooking something in the Report Generation toolkit?

Ultimately, what I really want is to print an XY graph and have the printout scale to fit the page, be oriented nicely, etc.  Saving the graph as a .PNG programmatically is cool and all, but the Windows program to view PNGs doesn't print well.  Right-clicking the graph and saving to a .BMP leads to similar issues.  Right-clicking and exporting the data to Excel allows me to laboriously construct an XY graph data-series by data-series, which then prints nicely.  Keyword: laboriously.

Suggestions?

coil__XL__helpmed.png

coil__XL__helpmed1.png

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.