+ Reply to Thread
Results 1 to 10 of 10

Try to make a dynamic graphic

  1. 07-06-2023, 08:21 AM #1
    Vinhas
    Vinhas is offline
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Try to make a dynamic graphic

    Hi everyone,

    In the file in attchament I need the last value in colunn H writte the same value in collunn I. I need also all the others colluns be with #N/D.

    So I have some problems to change the formula in collun I to give me the last value in collunn H.


    Thanks for your help,
    Regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-06-2023, 08:26 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,980

    Re: Try to make a dynamic graphic

    Are you still using Excel 2019?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-06-2023, 08:27 AM #3
    Vinhas
    Vinhas is offline
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Re: Try to make a dynamic graphic

    Yes I'm still using .
    Reply With QuoteRegister To Reply
  4. 07-06-2023, 08:29 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,980

    Re: Try to make a dynamic graphic

    In I4 copied down:

    =IF(ISERROR(H4),H4,LOOKUP(2,1/(NOT(ISERROR($H$4:$H$11))),$H$4:$H$11))

    =SE(É.ERRO(H4);H4;PROC(2;1/(NÃO(É.ERRO($H$4:$H$11)));$H$4:$H$11))
    Reply With QuoteRegister To Reply
  5. 07-06-2023, 09:30 AM #5
    Vinhas
    Vinhas is offline
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Re: Try to make a dynamic graphic

    thanks for your help.

    If I put your formula from I4 copied down it appears from I4 to I9 the value of 1500. I just need a formula to give me in collun I the last value in collun H. In this case must appears in I4;I5;I6;I7,I8 #N/D and in I9 appears 1500 (equal to H9 - Last value entry) and in I10 and I 11 again #N/D.

    Example 1: With your formula;
    Example 2: What I need.

    thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-06-2023, 09:39 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,980

    Re: Try to make a dynamic graphic

    Try this:

    =IF(ISERROR(H4),H4,IF(ROW()=LOOKUP(2,1/(NOT(ISERROR($H$4:$H$11))),ROW($H$4:$H$11)),H4,"#N/A"))

    =SE(É.ERRO(H4);H4;SE(LIN()=PROC(2;1/(NÃO(É.ERRO($H$4:$H$11)));LIN($H$4:$H$11));H4;"#N/A"))

    You didn't need two workbooks for that - you could have added your expected results to the same workbook.
    Reply With QuoteRegister To Reply
  7. 07-06-2023, 10:17 AM #7
    Vinhas
    Vinhas is offline
    Forum Contributor
    Join Date
    12-17-2019
    Location
    Portugal
    MS-Off Ver
    office 2019
    Posts
    167

    Re: Try to make a dynamic graphic

    thanks ! It works !!
    But Now I have a problem (sorry to bored you) with the graph. I would like the label in June (226.007 €) go automatilly to the value I put in July (230.000 €) and so on as I put new values. can you help me with this ?

    thanks again.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 07-06-2023, 10:19 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,980

    Re: Try to make a dynamic graphic

    This is a completely different question.

    Please mark THIS thread as SOLVED and open a NEW thread with a suitable title for the graph query. Thanks.
    Reply With QuoteRegister To Reply
  9. 07-06-2023, 10:31 AM #9
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,980

    Re: Try to make a dynamic graphic

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Reply With QuoteRegister To Reply
  10. 07-06-2023, 02:18 PM #10
    Joel Chacko
    Joel Chacko is offline
    Registered User
    Join Date
    11-23-2017
    Location
    Dubai
    MS-Off Ver
    MS 365 version 2208
    Posts
    13

    Re: Try to make a dynamic graphic

    Try this. It should suffice
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make a sumproduct dynamic
    By Tonx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2021, 02:51 PM
  2. [SOLVED] How to make the following code dynamic?
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2015, 03:55 PM
  3. [SOLVED] Fill gap between 2 graphic lines. Set dynamic series.
    By Calio in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-15-2014, 04:22 AM
  4. Excel 2007 : Dynamic graphic placement (chart or other)...
    By jwhitwell in forum Excel General
    Replies: 2
    Last Post: 05-24-2010, 06:09 PM
  5. Make dynamic charts more dynamic
    By Milo in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-12-2006, 04:10 AM
  6. [SOLVED] How to Make Graphic Uneditable
    By Chaplain Doug in forum Excel General
    Replies: 2
    Last Post: 05-31-2005, 08:05 PM
  7. Can someone help me make this dynamic?
    By Henry Stock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 03:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1