Issue with automatic range on excel's graph

Question

Issue with automatic range on excel's graph

Baptiste 25

Good morning, I have an isue with my microsoft graph : I use one graph to show results that change over time and assay. So to display correctly the values I ticked automatic range, it worked perfectly for my exemple but now it shows the values on a small part of the graph with the same parameters... what can I do ? 6aa07283-4dc1-4d2b-8134-71b056c253cb (964×287)

b9da0cf7-b88e-4d0e-879e-f2e516df0381 (1000×266)

If I manually change the values from 0.018 to 0.02 it works ; but not from 0.018 to 0.009 ... Thanks for reading.

Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff

2024-02-02T09:09:24.5866667+00:00

In my opinion this is related to the Axis Bounds and Units, you can modify the values manually, right click the Axis in chart- select Format Axis- then modify the Bounds and Units manually:
Baptiste 25 Reputation points

2024-02-02T12:20:09.7366667+00:00

Hi, Thank you for your answer. But I don't want to do it manually (I won't be able because of the password I'll put on the sheet). I thought that the auto thing will use the best value for the axis. Do you know if it is possible to use a macro to define both minimum and maximum of units and bounds ?

1 answer

Your answer

Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff

2024-02-02T09:09:24.5866667+00:00

In my opinion this is related to the Axis Bounds and Units, you can modify the values manually, right click the Axis in chart- select Format Axis- then modify the Bounds and Units manually:
Baptiste 25 Reputation points

2024-02-02T12:20:09.7366667+00:00

Hi, Thank you for your answer. But I don't want to do it manually (I won't be able because of the password I'll put on the sheet). I thought that the auto thing will use the best value for the axis. Do you know if it is possible to use a macro to define both minimum and maximum of units and bounds ?

Answer 1

Ok so I saw that we can make a macro to select x and y min/max values so I made this macro and it display what I want. But still no clue why the automatic range didn't work properly ... maybe my difference betwwen min and max is to small ... Linked to a button ActiveSheet.ChartObjects("Graphique 7").Activate ActiveChart.Axes(xlCategory).Select ActiveChart.Axes(xlCategory).MinimumScale = Range("P63") - 1 / 100 * Range("P63") ActiveChart.Axes(xlCategory).MaximumScale = Range("X63") + 1 / 100 * Range("X63") Application.CommandBars("Format Object").Visible = False

Share via

Issue with automatic range on excel's graph

1 answer

Your answer