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

%3CLINGO-SUB%20id%3D%22lingo-sub-1117548%22%20slang%3D%22en-US%22%3EHow%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%20it%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117548%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20formula%20calculator%20that%20results%20in%20a%20single%20point%20on%20a%20graph.%20You%20can%20change%20the%20values%20in%20the%20the%20spreadsheet%20and%20it%20updates%20the%20resulting%20point%20on%20the%20line%20graph%2C%20but%20is%20there%20a%20way-%20on%20any%20platform-%20that%20allows%20me%20to%20move%20the%20point%20on%20the%20graph%20manually%20and%20it%20automatically%20adjusts%20the%20amount%20of%20each%20ingredient%20to%20correspond%20to%20the%20resulting%20end%20point%3F%20All%20advice%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1117548%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117632%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117632%22%20slang%3D%22en-US%22%3EI%20suppose%20you%20mean%20filtering%20the%20line%20chart%20so%20that%20the%20changes%20occurs%20on%20the%20Pivot%20Table.%20%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20that's%20what%20you%20mean%2C%20you%20need%20to%20create%20a%20PivotChart%20from%20a%20PivotTable.%20On%20the%20chart%2C%20you%20will%20see%20filter%20buttons%20that%20allows%20you%20to%20filter%20the%20chart%20and%20the%20changes%20impact%20the%20PivotTable.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117715%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F524995%22%20target%3D%22_blank%22%3E%40JReee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDragging%20data%20points%20in%20a%20graph%20to%20manipulate%20the%20underlying%20data%20was%20a%20great%20feature%20I%20used%20a%20lot%20many%20years%20ago.%20It%20was%20available%20in%20Excel%202003%20but%20disappeared%20with%20the%202007%20version%20(says%20Google).%20Found%20a%20video%20by%20%22MrExcel3%22%20on%20Youtube%20demonstrating%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D5ztk9HGGjbk%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D5ztk9HGGjbk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117964%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117964%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20that%20was%20a%20nice%20feature.%20Just%20found%20some%20summary%20of%20what%20was%20redesigned%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpeltiertech.com%2Fwhat-happened-to-my-favorite-excel-2003-chart-feature%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWhat%20happened%20to%20my%20favorite%20Excel%202003%20Chart%20feature%3F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1119242%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20that's%20exactly%20what%20I%20mean.%20Too%20bad%20Microsoft%20has%20been%20so%20apathetic%20about%20adding%20it%20to%20any%20subsequent%20versions%20of%20Excel.%20Seems%20like%20customer%20interest%20in%20this%20feature%20remains%20enthusiastic%20enough%20that%20they%20should%20release%20an%20update%20that%20includes%20this%20feature.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1120051%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120051%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F524995%22%20target%3D%22_blank%22%3E%40JReee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20still%20available%20if%20you%20really%20need%20the%20functionality.%26nbsp%3B%20Insert%20menu%2C%20Object%2C%20Create%20from%20file%3A%20Microsoft%20Graph%20Chart%20(Graph.exe).%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166279iA3B6F8C044826997%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1120103%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat!%20Windows%20only%2C%20I%20suspect.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1120116%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120116%22%20slang%3D%22en-US%22%3EAfter%20you%20create%20a%20chart%2C%20you%20can%20change%20the%20data%20series%20in%20two%20ways%3A%3CBR%20%2F%3EUse%20the%20Select%20Data%20Source%20dialog%20box%20to%20edit%20the%20data%20in%20your%20series%20or%20rearrange%20them%20on%20your%20chart.%3CBR%20%2F%3EUse%20chart%20filters%20to%20show%20or%20hide%20data%20in%20your%20chart.%3CBR%20%2F%3EEdit%20or%20rearrange%20a%20series%3CBR%20%2F%3ERight-click%20your%20chart%2C%20and%20then%20choose%20Select%20Data.%3CBR%20%2F%3ESelect%20Data%20Source%20dialog%20box%3CBR%20%2F%3EIn%20the%20Legend%20Entries%20(Series)%20box%2C%20click%20the%20series%20you%20want%20to%20change.%3CBR%20%2F%3EClick%20Edit%2C%20make%20your%20changes%2C%20and%20click%20OK.%3CBR%20%2F%3EChanges%20you%20make%20may%20break%20links%20to%20the%20source%20data%20on%20the%20worksheet.%3CBR%20%2F%3ETo%20rearrange%20a%20series%2C%20select%20it%2C%20and%20then%20click%20Move%20Up%20Move%20Up%20button%20or%20Move%20Down%20Move%20Down%20button%20.%3CBR%20%2F%3EYou%20can%20also%20add%20a%20data%20series%20or%20remove%20them%20in%20this%20dialog%20box%20by%20clicking%20Add%20or%20Remove.%20Removing%20a%20data%20series%20deletes%20it%20from%20the%20chart%E2%80%94you%20can%E2%80%99t%20use%20chart%20filters%20to%20show%20it%20again.%3CBR%20%2F%3EIf%20you%20want%20to%20rename%20a%20data%20series%2C%20see%20Rename%20a%20data%20series.%3CBR%20%2F%3EFilter%20data%20in%20your%20chart%3CBR%20%2F%3ELet%E2%80%99s%20start%20with%20chart%20filters.%3CBR%20%2F%3EClick%20anywhere%20in%20your%20chart.%3CBR%20%2F%3EClick%20the%20Chart%20Filters%20button%20Chart%20Filters%20button%20next%20to%20the%20chart.%3CBR%20%2F%3EOn%20the%20Values%20tab%2C%20check%20or%20uncheck%20the%20series%20or%20categories%20you%20want%20to%20show%20or%20hide.%3CBR%20%2F%3EValues%20tab%20in%20the%20Chart%20Filters%20gallery%3CBR%20%2F%3EClick%20Apply.%3CBR%20%2F%3EIf%20you%20want%20to%20edit%20or%20rearrange%20the%20data%20in%20your%20series%2C%20click%20Select%20Data.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1121213%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20manually%20move%20the%20point%20on%20a%20graph%20so%20it%20changes%20the%20values%20on%20the%20formula%20that%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1121213%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428790%22%20target%3D%22_blank%22%3E%40Patrick2788%3C%2FA%3E%20is%20there%20an%20option%20that%20works%20for%20Mac%3F%3CBR%20%2F%3EThank%20you!%3C%2FLINGO-BODY%3E
New Contributor

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 any platform- that allows me to move the point on the graph manually and it automatically adjusts the amount of each ingredient to correspond to the resulting end point? All advice helpful.

9 Replies
I suppose you mean filtering the line chart so that the changes occurs on the Pivot Table.

If that's what you mean, you need to create a PivotChart from a PivotTable. On the chart, you will see filter buttons that allows you to filter the chart and the changes impact the PivotTable.

@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 

@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.

@JReee 

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

clipboard_image_0.png

After you create a chart, you can change the data series in two ways:
Use the Select Data Source dialog box to edit the data in your series or rearrange them on your chart.
Use chart filters to show or hide data in your chart.
Edit or rearrange a series
Right-click your chart, and then choose Select Data.
Select Data Source dialog box
In the Legend Entries (Series) box, click the series you want to change.
Click Edit, make your changes, and click OK.
Changes you make may break links to the source data on the worksheet.
To rearrange a series, select it, and then click Move Up Move Up button or Move Down Move Down button .
You can also add a data series or remove them in this dialog box by clicking Add or Remove. Removing a data series deletes it from the chart—you can’t use chart filters to show it again.
If you want to rename a data series, see Rename a data series.
Filter data in your chart
Let’s start with chart filters.
Click anywhere in your chart.
Click the Chart Filters button Chart Filters button next to the chart.
On the Values tab, check or uncheck the series or categories you want to show or hide.
Values tab in the Chart Filters gallery
Click Apply.
If you want to edit or rearrange the data in your series, click Select Data.