Home

Question about saving the scales of a graph in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-748062%22%20slang%3D%22en-US%22%3EQuestion%20about%20saving%20the%20scales%20of%20a%20graph%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748062%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20currently%20working%20on%20a%20project%20on%20excel.%20Basically%2C%20my%20excel%20sheet%20contains%20a%20graph%20and%20a%20macro%20called%20macro1().%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20steps%20i%20should%20follow%20during%20my%20procedures%20are%20as%20follow%20(%20i%20cannot%20change%20them)%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3EStep%201%3A%20Run%20the%20macro1()%26nbsp%3B%3C%2FP%3E%3CP%3EStep%202%3A%20Look%20at%20the%20graph%20and%20decide%20whether%20the%20minimum%20and%20maximum%20scales%20of%20the%20graph%20should%20be%20changed.%20If%20yes%2C%20change%20the%20scales%20manually.%20I%20do%20this%26nbsp%3B%20using%20one%20of%20your%20graph%20properties%20%22Format%20Axis%22%20where%20i%20manually%20enter%20the%20values%20i%20want%20for%20the%20minimum%20and%20the%20maximum%20scale.%26nbsp%3B%3C%2FP%3E%3CP%3EStep%203%3A%20After%20changing%20the%20values%20of%20the%20scales%2C%20run%20macro1()%20once%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20the%20issue%20appears%20here.%20After%20completing%20step3%2C%20if%20i%20look%20back%20at%20the%20chart%20i%20see%20that%20the%20values%20that%20i%20manually%20entered%20in%20step2%20are%20not%20there%20anymore%20and%20are%20reset%20to%20their%20original%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20make%20sure%20the%20values%20i%20enter%20in%20step2%20remain%20on%20the%20graph%20even%20after%20running%20the%20macro%20once%20again%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20felt%20like%20this%20is%20a%20weird%20issue%20because%20if%20i%20do%20the%20exact%20same%20steps%20on%20another%20workbook%20i%20work%20on%2C%20i%20am%20not%20having%20this%20issue%2C%20the%20values%20are%20being%20saved.%20I%20am%20only%20having%20trouble%20with%20one%20particular%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20your%20help%20%3A)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-748062%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748210%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20about%20saving%20the%20scales%20of%20a%20graph%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748210%22%20slang%3D%22en-US%22%3EI'd%20say%20depends%20on%20your%20macro.%20What%20does%20it%20contain%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748262%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20about%20saving%20the%20scales%20of%20a%20graph%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748262%22%20slang%3D%22en-US%22%3EIt%20is%20a%20macro%20running%20one%20big%20sub%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748316%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20about%20saving%20the%20scales%20of%20a%20graph%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748316%22%20slang%3D%22en-US%22%3EWell%2C%20yes%20and%20if%20that%20sub%20fiddles%20with%20the%20chart%2C%20it%20might%20cause%20what%20you%20describe.%3C%2FLINGO-BODY%3E
Celine_nader
New Contributor

Hello,

 

I am currently working on a project on excel. Basically, my excel sheet contains a graph and a macro called macro1().

 

The steps i should follow during my procedures are as follow ( i cannot change them) : 

Step 1: Run the macro1() 

Step 2: Look at the graph and decide whether the minimum and maximum scales of the graph should be changed. If yes, change the scales manually. I do this  using one of your graph properties "Format Axis" where i manually enter the values i want for the minimum and the maximum scale. 

Step 3: After changing the values of the scales, run macro1() once again.

 

However, the issue appears here. After completing step3, if i look back at the chart i see that the values that i manually entered in step2 are not there anymore and are reset to their original value.

 

Is there a way to make sure the values i enter in step2 remain on the graph even after running the macro once again?

 

I felt like this is a weird issue because if i do the exact same steps on another workbook i work on, i am not having this issue, the values are being saved. I am only having trouble with one particular workbook.

 

Thank you so much for your help :) 

3 Replies
I'd say depends on your macro. What does it contain?
It is a macro running one big sub
Well, yes and if that sub fiddles with the chart, it might cause what you describe.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies