+ Reply to Thread
Results 1 to 4 of 4

Touchable charts on excel

Hybrid View

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Madrid
    MS-Off Ver
    Excel 2003
    Posts
    2

    Touchable charts on excel

    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?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Touchable charts on excel

    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.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-17-2012
    Location
    Madrid
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Touchable charts on excel

    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.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Touchable charts on excel

    How's your javascript?

    There's an example here for column/combo charts: http://jsfiddle.net/highcharts/AyUbx/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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