[Webinar] Learn how to a build a cloud-first strategyRegister Now


Excel 2010: Charts with feedback? (Interactive?)

Posted on 2012-08-13
Medium Priority
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

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38287136

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 http://blogs.office.com/b/microsoft-excel/archive/2009/11/02/excel-add-in-for-manipulating-points-on-charts-mpoc.aspx

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

ID: 38287663
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?

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

867 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