| Author |
 Topic  |
|
|
vizinho
1 Posts |
 Posted - 06/03/2014 : 3:09:54 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 9.1.0 (64 bits)
Operating System: Windows 7 (64 bits)
Hi,
Here is what I am doing: I created a pivot table from access data. I had already plotted some graphs and saved the project. When I added new data in access and reimported the data into Origin, all my graphs were plotted with the wrong data, because all data displaced one column to the right, because the pivot is alphabetically ordering. I want to know if there is a way to plot my graphs and when the column move, the graph continue to plot the same data.
Thanks! |
|
|
lkb0221
China
497 Posts |
Posted - 06/04/2014 : 2:07:41 PM
|
Hi,
When you do re-import, actually all your data is replaced by new ones, not just moved.
One way is to use script to import, that is, import new file to a temp workbook, insert a new column at the beginning of your working book and copy the first column from temp book into it.
If you need our help about this, please email us some sample files so we can working on it.
Zheng
OriginLab |
Edited by - lkb0221 on 06/04/2014 2:08:17 PM |
 |
|
| |
Topic |
|
|
|
Keep the graph data when the column displace