| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Chart Title or Text Box Linked to cell & sheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| if a cell contains certain text, cut and paste to another sheet | Excel Worksheet Functions | |||
| Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
| Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel | |||
Threaded Mode
