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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies