How to adjust X-axis Label get full sticks though "interval between marks: 1" ?

Question

How to adjust X-axis Label get full sticks though "interval between marks: 1" ?

DMAT 0

I want to plot a Pareto chart.

If I use the default Pareto type in excel ribbon, X-axis show full of tick marks.

default excel

If I combine the column and line chart, I can get the same visualization but x-axis did not show all tick marks though I've already set up "interval between marks: 1" and same type of font + font size.

combine chart

Please show me how to solve this.

Thank you so much for your help!

1 answer

Your answer

Answer 1

Jiajing Hua 18,065 Moderator

Hi @DMAT

If you stretch the chart for more room, will this issue persist?

Please go to Format Axis interface, set 'Specify interval unit 1' for Axis Options Labels for a check.

Any issues, welcome to post back.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

DMAT 0 Reputation points

2024-01-08T08:16:05.2133333+00:00

Hi Jiajing Hua-MFST,

I'd adjust the "interval between marks: 1" like you suggested (both characters spacing in Font too).

Of course, I can increase the X-axis width or decrease marks to show fully.

I pay attention to technical solutions:

With the same data: the same width of X-Axis, the same number of tickers, and the same font size + type, Excel's pareto chart can show full marks but why Combo chart cannot.

In this Screen capture, I put a combo chart on the default Microsoft Excel Pareto chart to show more detail. :)

Would you mind showing me more solutions, Jiajing Hua_MFST?

Thank you so much!
Jiajing Hua 18,065 Reputation points Moderator

2024-01-09T09:06:30.6833333+00:00

Hi @DMAT

Thanks for your back.

I think this may be related to the different chart generation mechanism designed by the development team.

According to my testing, even you adjust the settings (interval spacing and font) for combination charts (Column and Line charts) later, we cannot make the two charts have exactly the same X-axis.

For this issue, you still need some other manual effort, such as stretching the chart area.

Thanks for your understanding.

Share via

How to adjust X-axis Label get full sticks though "interval between marks: 1" ?

1 answer

Your answer