+ Reply to Thread
Results 1 to 2 of 2

Interactive Graph with total result - Cant find a solution

  1. #1
    Registered User
    Join Date
    10-25-2019
    Location
    Buenos Aires
    MS-Off Ver
    2016
    Posts
    4

    Interactive Graph with total result - Cant find a solution

    Dear Everybody,

    I writing out of exhausting looking for a solution. Maybe I am aiming for something unnecessary complex but I was looking to make graph that dynamically changed based on a drop down list. But my plans are being hindered by a specific formula.

    The aim would be as follow: The graphs would feed based o formula that shows the total budget of Project A compared to the total of the budget of the portfolio.

    I am uploading an example below.

    In Sheet1 we have a database of all the projects. Each project has a specific budget and linked to a specific donor. Furthermore, the Donors have other projects.

    The aim is to have, in Sheet2, a small, dynamic, summary visually aided by a graph that shows the ratio of the project in the clients portfolio. As seen in Sheet 2, once can chose of the project based on a drop-down list and the other cells change accordingly. The formula I cant quite make out is the ratio formula (Total of Project A compared to the total of the budget of the portfolio) that changes accordingly to the drop-down list. I have tried the following, but it hasn't worked:

    =SUM(INDEX(Sheet1!A2:C7,0,MATCH(B6,0,Sheet1!C:C)))


    I would deeply appreciate any tip regarding this formula. I have looked up in the forum and haven found a solution. If there is, I apologize for the repetitive thread.

    Kind regards,

    Javier
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,187

    Re: Interactive Graph with total result - Cant find a solution

    Is this what you're looking for?

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

+ 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. Interactive graph, is it possible
    By mrsak87 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-26-2019, 01:14 PM
  2. [SOLVED] Dynamic Interactive Line Graph
    By takeawalkk in forum Excel General
    Replies: 2
    Last Post: 08-24-2017, 02:49 PM
  3. Interactive graph with table cells
    By bvwn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-23-2017, 04:24 AM
  4. Can't find a solution with a graph
    By Marpal86 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-25-2013, 07:27 PM
  5. Interactive Excel Graph???
    By baileyhsi in forum Excel General
    Replies: 1
    Last Post: 06-25-2010, 11:11 AM
  6. Interactive Start Date with a Graph
    By lmj4 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-21-2010, 05:12 AM
  7. Setup up a formula for an Interactive solution ?
    By Concrete_Engineer in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-27-2010, 08:09 PM

Tags for this Thread

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