I was wondering if you can make a chart, more specifically a pie, where you could move the limits of each slice of the pie, and that would also update the value of the table that pie is based on.
And if you can't do it on Excel how would you do it?
I was wondering if you can make a chart, more specifically a pie, where you could move the limits of each slice of the pie, and that would also update the value of the table that pie is based on.
And if you can't do it on Excel how would you do it?
With xl2003 you can use graphical goal seek.
Select the pie
Select a slice
hover the cursor over outer edge of pie at the end of the slice, where it meets the next slice. The cursor should change from arrow to plus sign.
You can not drag slide to increase/decrease value.
If you cannot do it directly on Excel, how would you do it?
I was thinking of a web page that will import an Excel file, and with <canvas> make a pie whose slices can be changed and that event will trigger an update on a HTML table that has imported the values of the Excel, once the changes on the pie have finish there will be a "Save" button that will import the values of the HMTL table to the Excel file.
How's your javascript?
There's an example here for column/combo charts: http://jsfiddle.net/highcharts/AyUbx/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks