Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Use references in chart titles

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Robert F. Cavedo
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I refer to the contents of a cell when entering the Chart Titles i.e. Title, X-axis, y-axis? All of the data is in the spreadsheet. It seems to be a waste of time to re-type it for the chart wizard.

    Thanks

    Bob

  2. #2
    New Member
    Join Date
    Apr 2002
    Location
    Robert F. Cavedo
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Question remains unanswered.
    Does that mean it can't be done?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Excel Help Index topic for "Link a chart title or text box to a worksheet cell".

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Robert F. Cavedo
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Works perfectly
    I've used the cell reference technique between worksheets. It just never occured to me that I could use it with the chart wizard.

    Thanks very much. It will save me much time and typing. Especially since the change will be dynamic.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •