+ Reply to Thread
Results 1 to 8 of 8

Chart only plots if cell value is entered manually

  1. #1
    Forum Contributor
    Join Date
    06-18-2008
    Posts
    122

    Chart only plots if cell value is entered manually

    Hi all.

    I have a smiley chart I found that uses a macro, but I cannot get it to work as I want it to.

    If I input the total manually it works, but I want it to work from a cell that contains a formula. I have attached the sheet for you to have a look at. The idea is that I input amounts each month, the total at the bottom adds the values up and plots the chart.

    Any ideas would be appreciated.

    Thanks,

    Tony
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,077

    re: Chart only plots if cell value is entered manually

    The test of the Target address will only pass if the cell changed was C13.
    As this is a formula unless you re-enter the formula the shape will not update.

    This revision checks the dependent cells to see if C13 is affected.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    06-18-2008
    Posts
    122

    re: Chart only plots if cell value is entered manually

    Thanks for getting back to me Andy.

    I've put the new code in, but it its working? It doesn't go up in the scale I want it to, and it seems that it is only effected by figures added to column C. The target I want set is 10000 (so fully smiling if 10000 or over, and a medium smile if the cell states 5000.

    Thanks for your help,

    Tony

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,077

    re: Chart only plots if cell value is entered manually

    So I see. The second dependency returned if not C13 but D13 or E13.

    Try this revision
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-18-2008
    Posts
    122

    re: Chart only plots if cell value is entered manually

    Hi Andy.

    It still isn't working. Its strange because if you delete the formula in C13, and try typing some figures in the cell yourself, it works perfectly? It seems as soon as you put the sum formula back in to add all the monthly amounts, it goes pear shaped!

    Tony

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,077

    re: Chart only plots if cell value is entered manually

    works for me if you enter figures in the main table
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    06-18-2008
    Posts
    122

    re: Chart only plots if cell value is entered manually

    I don't get it! I've tried your version too, but the same thing happens - it doesn't move as it should. I just filled in the whole table, the total went to 14000 and the thing was still frowning at me!!

    Could it be the settings I've got on my version? Thanks for all your help so far Andy.

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,077

    re: Chart only plots if cell value is entered manually

    I assume you have enabled the macros?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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