I need to create charts from data collected via a com port. As it stands, the data is written to sheet 1. Chart 1 is ready to plot data as it is written. Once the data is complete, I copy sheet 1 and chart 1. This results in sheet 1(2) and Chart 1(2). All references to sheet 1 on the newly created chart 1(2) automatically changes to refer to sheet 1(2). This applies to data ranges, Chart Title, Axis names.
When creating text boxes refering to sheet1!$A$1, the reference does not automacially change to sheet 1(2)!$A$1. Can this be done?
If not, can I create multiple chart titles?
Any help or insight is welcome.
Regards,
CaliberX
When creating text boxes refering to sheet1!$A$1, the reference does not automacially change to sheet 1(2)!$A$1. Can this be done?
If not, can I create multiple chart titles?
Any help or insight is welcome.
Regards,
CaliberX