View previous topic :: View next topic |
Author |
Message |
chljl
Joined: 29 Nov 2005 Posts: 23
|
Posted: Wed Dec 09, 2009 6:30 pm Post subject: Excel data source |
|
|
I use DPlot to do a lot graphing with Excel data. But sometime I can't remember the data source of the graph. Can DPlot add some notes in the grf file to show the data source, including the sheet name and the data range? That will be useful. |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Thu Dec 10, 2009 12:42 pm Post subject: |
|
|
When using the Add-In, the sheet name is used for a title line. I hadn't considered using the range of the data anywhere, though - that's a good suggestion. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
chljl
Joined: 29 Nov 2005 Posts: 23
|
Posted: Fri Dec 11, 2009 4:03 am Post subject: |
|
|
I usually delete the title line for the file name so that I can put the graph in my formal documents. But later on when I look back these graph I can't find what data I used to produce them. So I would appreciate if you can record these information as remarked lines in the grf files. |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2311 Location: Vicksburg, Mississippi
|
Posted: Fri Dec 11, 2009 7:52 pm Post subject: |
|
|
The next version will include a hidden note (that you can make visible by clicking on the Note button) in the form "Source: [filename]Sheet Name!RxCx:RyCy". As of now that hidden note is placed just above the top left corner of the plot, though you can of course move it wherever you want by clicking the Note button. Within the DPlot file, the note will show up as something like:
Code: | NoteV3
-1,0,33,8,4,0,0,-1
Source: [examples.xls]XYYY!R10C1:R211C13
|
The only thing that's a little iffy for me is what to do if you're appending data from Excel to an existing graph. No consideration is given to whether the new note will overlap any previously-existing note, and I don't see a good way around that. Since the notes are hidden that isn't a huge deal and as far as I can tell will fulfill your request in any case. I'm just fidgeting over figuring out a better way of handling this. If it changes at all it will be to change the location, which is mostly irrelevant as far as what you wanted.
Thanks for the suggestion. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
chljl
Joined: 29 Nov 2005 Posts: 23
|
Posted: Sat Dec 12, 2009 12:58 am Post subject: |
|
|
This is real excellent customer support!!! |
|
Back to top |
|
|
|