P pvaishnavi New Member May 3, 2013 #1 Is it possible to have a dynamic chart in Excel wherein I can play around with the graph and the data automatically changes according to the resultant graph??
Is it possible to have a dynamic chart in Excel wherein I can play around with the graph and the data automatically changes according to the resultant graph??
Hui Excel Ninja Staff member May 3, 2013 #2 Pvaishnavi Firstly, Welcome to the Chandoo.org Forums Can you please read the 3 Sticky green posts at the main forum page Then have a read of http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
Pvaishnavi Firstly, Welcome to the Chandoo.org Forums Can you please read the 3 Sticky green posts at the main forum page Then have a read of http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
Sajan Excel Ninja May 3, 2013 #3 Hello @Pvaishnavi, I am assuming you wanted to manipulate the chart directly. If so, check out the following add-in. http://blogs.office.com/b/microsoft-excel/archive/2009/11/02/excel-add-in-for-manipulating-points-on-charts-mpoc.aspx I have not tried it, but hope it gives you what you want. Cheers, Sajan.
Hello @Pvaishnavi, I am assuming you wanted to manipulate the chart directly. If so, check out the following add-in. http://blogs.office.com/b/microsoft-excel/archive/2009/11/02/excel-add-in-for-manipulating-points-on-charts-mpoc.aspx I have not tried it, but hope it gives you what you want. Cheers, Sajan.