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
Highlighted
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
Highlighted
I'd say depends on your macro. What does it contain?
Highlighted
It is a macro running one big sub
Highlighted
Well, yes and if that sub fiddles with the chart, it might cause what you describe.
Related Conversations
Repeating rows but not for entire sheet
RRPI-1997 in Excel on
2 Replies
IF function
qexle in Excel on
2 Replies
Excel Help needed
NojMc in Excel on
1 Replies
IFS with AND and multiple falses
Bradley79 in Excel on
1 Replies