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
--
CaliberxPosted from
http://www.pcreview.co.uk/ newsgroup access