1.298 FAQ-1191 How to get graph auto updated when adding or deleting columns?

Auto-Update-Plot-When-Add-Remove-Col

Last Update: 11/29/2023

If you plot the whole worksheet data (by clicking on the top-left corner cell or highlighting all columns), you can set the following to get graph auto updated when adding, inserting or deleting columns in the source worksheet:

1. Activate the graph window you want to set.
2. Select menu Window: Script Window.
3. In the Script Window, enter following script and press Enter key to run:

   layer.groupn.allCols = 1

   where n is the nth plot group in the active graph layer.

Some limitations you should know...

• This method requires the plot group comprised of one single X column and all Y columns to the right of that X column. Other cases like XYXY... structure, are not supported.
• If you delete many Y columns so there is only one Y column left, the plot is ungrouped automatically. When you add new columns later, the graph will auto update but the group settings (color list, shape increment, etc.) are lost.

Keywords:group lots, update plot dynamically, add column, remove column, insert column, delete column