+ Reply to Thread
Results 1 to 2 of 2

Can Excel us a cell as a chart title when using more than 1 colum of data ?

  1. #1
    Registered User
    Join Date
    08-27-2009
    Location
    Dundee
    MS-Off Ver
    Excel 2003
    Posts
    7

    Can Excel us a cell as a chart title when using more than 1 colum of data ?

    I have a very simple template which plots out means and standard errors of a treatment structure. The input is from an analysis of variance so I want to have the significance levels dispalayed in the title. This is simple for a single col of data but when there are more then one it doesn't use a cell to populate the chart title. From the sheet I've attched the first and second chart have dynamic titles, if you change cell F10 from 0.364 to 0.001 the title on the second chart will change to "Input (**)" as it uses M19 for the title. The problem is that for the 3rd chart titled "CV*TR (NS)" any change has to be done manually (change cell F15 to 0.04 and this changes cell J43 to "CV*TR (*)".
    ANyone got any suggestions?

    Thanks in advance
    Susan

    example.xlsx

  2. #2
    Registered User
    Join Date
    08-27-2009
    Location
    Dundee
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Can Excel us a cell as a chart title when using more than 1 colum of data ?

    I've just read Andy Pope's post re:type in the fomate bar. Works perfectly tHANKS

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Chart title referenced from a cell
    By tlacloche in forum Excel Charting & Pivots
    Replies: 58
    Last Post: 04-11-2013, 04:33 PM
  2. [SOLVED] Changing Chart Title Cell reference with Excel VBA
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2012, 02:39 PM
  3. [SOLVED] Excel: Can I change Chart-title/category/value from a sheet-cell?
    By femke in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-24-2005, 12:05 PM
  4. Excel chart - how to assign the file name in the chart title?
    By TGreen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-16-2005, 06:05 AM
  5. Pasting Objects into Chart title and Axis title
    By Sam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-06-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1