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 |
#2
|
|||
|
|||
Re-reading my post, it seems to be a little winded and not sure if I am
clear enough. The answer to the following question should give me the help I require. How do I make a text box behave the exact same way a chart title does when copying the data sheet and the related chart? Thanks again. CaliberX |
#3
|
|||
|
|||
Save the workbook with the worksheet and chart you want to copy. Select
the sheet and chart, and Move (don't Copy) them to a new workbook. Close the original workbook without saving. Reopen the workbook, then Move the copied sheets into the original workbook. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ CaliberX wrote: Re-reading my post, it seems to be a little winded and not sure if I am clear enough. The answer to the following question should give me the help I require. How do I make a text box behave the exact same way a chart title does when copying the data sheet and the related chart? Thanks again. CaliberX |
#4
|
|||
|
|||
Thanks for your input Jon. I'll try this method next time I am in the
field and I'll let you know how it works out. The method sounds a little too complex to use while in the field and being distracted with the experiment / audience. I fear for some data loss. However, I've been reading quite a few of your posts and appreciate the suggestion and all the help you give freely to all. Oddly, I feel relieved that its not as simple as I imagined. Thank you CaliberX |
#5
|
|||
|
|||
I'll bet with a little practice, you could do it in about 3 seconds. The
steps are pretty easy, and the file you just closed is in the Recently Used list. - Jon CaliberX wrote: Thanks for your input Jon. I'll try this method next time I am in the field and I'll let you know how it works out. The method sounds a little too complex to use while in the field and being distracted with the experiment / audience. I fear for some data loss. However, I've been reading quite a few of your posts and appreciate the suggestion and all the help you give freely to all. Oddly, I feel relieved that its not as simple as I imagined. Thank you CaliberX |
#6
|
|||
|
|||
If the text box can be colocated with the chart title, create a
composite title cell. Suppose the actual title is in B1 and the textbox content is in A1, then in C1 enter =A1&char(10)&B1. Now, use C1 for the chart title. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article .com, says... Re-reading my post, it seems to be a little winded and not sure if I am clear enough. The answer to the following question should give me the help I require. How do I make a text box behave the exact same way a chart title does when copying the data sheet and the related chart? Thanks again. CaliberX |
Reply |
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 |