[Solved] Customize chart axes number format

[drypatrick]

Good morning,
I would like to know if there is a way to customize the axes number format with the macro, as is possible to do with the GUI like in the attached img.
Thanks very much!

[MrProgrammer]

I would like to know if there is a way to customize the axes number format with the macro

Please search first before posting. I found this in about ten seconds with a search: [Solved] Seting NumberFormat for YAxis in a chart

Search found 45 matches: chart axis

Or try a search for axes instead of axis. If you need more assistance, you are more likely to get the problem solved quickly if you attach a chart demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself).

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[drypatrick]

Thank you very much!!!!

[legalnan]

The Y axis automatically ranges from zero to 180. I would prefer 135 to 165. Can you please tell me how to do that? Thanks

[MrProgrammer]

Please review our forum policy: One issue, one thread.

You have posted in a solved topic which belongs to drypatrick and have asked a new question, legalnan. The original question concerned customizing the axes number format. I have locked the topic to prevent any responses to your new, unrelated question. Please open your own topic to discuss setting the Y-axis range. Use the Calc forum if you want to set the range with the standard user interface (Format → Axis → Y axis). Use the Macros and UNO API forum if you want to write a macro to set the range.