Forum Discussion

JReee's avatar
JReee
Copper Contributor
Jan 20, 2020

How do I manually move the point on a graph so it changes the values on the formula that created it?

I have a formula calculator that results in a single point on a graph. You can change the values in the the spreadsheet and it updates the resulting point on the line graph, but is there a way- on an...
excel
Excel on Mac
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 20, 2020

JReee 

Dragging data points in a graph to manipulate the underlying data was a great feature I used a lot many years ago. It was available in Excel 2003 but disappeared with the 2007 version (says Google). Found a video by "MrExcel3" on Youtube demonstrating it. 

https://www.youtube.com/watch?v=5ztk9HGGjbk 

  • JReee's avatar
    JReee
    Copper Contributor
    Jan 21, 2020

    Riny_van_Eekelen 

    Thanks, that's exactly what I mean. Too bad Microsoft has been so apathetic about adding it to any subsequent versions of Excel. Seems like customer interest in this feature remains enthusiastic enough that they should release an update that includes this feature.

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Jan 21, 2020

      JReee 

      It's still available if you really need the functionality.  Insert menu, Object, Create from file: Microsoft Graph Chart (Graph.exe).

      • JReee's avatar
        JReee
        Copper Contributor
        Jan 21, 2020
        Patrick2788 is there an option that works for Mac?
        Thank you!

Resources