Excel 2010: Charts with feedback? (Interactive?)

Posted on 2012-08-13
Last Modified: 2012-08-13
Hi experts!

Usually in Excel you generate charts from some rows and colums of data. I would like to know, if there is a possibility to have the reverse direction:

Drag the values of chart "data points" so that Excel adjusts the values in the tables.

I would like to use this mechanism for planning scenarios with uncertain parameters in such a way that I can "play around" with the graphs and Excel does all the math in the background.

If this is not possible with the standard Excel functions I would like to know, if it is possible to code such a mechanism or if there are third party tools that allow such proceeding. I am very sure I am not the only person in the world that needs have a flexible and graphical approach for sales forecasts etc.

Thank you very much in advance for helping me!
Question by:iThms
    LVL 50

    Accepted Solution


    In Excel 2003 and earlier that functionality was native, but it was dropped with Excel 2007. There is an add-in from Microsoft called "Excel Add-In for Manipulating Points on Charts (MPOC)" at

    I have not tested this with 2010, though, but since the charting engine is basically the same for 2007 and 2010, it should work in 2010 as well.

    cheers, teylyn

    [edit: just installed it on 2010 and it works.]

    Author Closing Comment

    I just saw that UNDO is not supported with the PlugIn. I can live with that, but I think this should be noted here.

    Any other (maybe 3rd party) PlugIns that you know of?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now