Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 15th 05, 09:33 PM
Caliberx
 
Posts: n/a
Default 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   Report Post  
Old June 16th 05, 01:20 AM
CaliberX
 
Posts: n/a
Default

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   Report Post  
Old June 16th 05, 02:38 AM
Jon Peltier
 
Posts: n/a
Default

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   Report Post  
Old June 16th 05, 04:10 AM
CaliberX
 
Posts: n/a
Default

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   Report Post  
Old June 16th 05, 11:35 PM
Jon Peltier
 
Posts: n/a
Default

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   Report Post  
Old June 17th 05, 04:59 PM
Tushar Mehta
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
if a cell contains certain text, cut and paste to another sheet Mili Excel Worksheet Functions 1 April 4th 05 04:18 AM
Help inserting a Cell Value in a Text Cell Dave Excel Worksheet Functions 5 March 5th 05 09:06 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 03:37 PM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017