Share via

How to break horizontal bar chart axis?

Anonymous
2024-01-14T10:43:06+00:00

Hi, I am trying to create a horizontal bar chart for the data below.

Keywords Lands (Primary)
career singapore 34,816
sg employment 9,294
singapore vacancy 8,125
career job opportunities 6,767
career options 5,173
career opportunities 3,088
vacancies singapore 3,026
job vacancies singapore 2,032
careers future singapore 1,392
job opportunities part time 1,341
career coaching 889
career support 843
career guidance 838
career choices 706
career transition program 675
career services singapore 669
sgcareers 650
careers advice 649
hotel jobs in singapore 542
part time singapore 492
career portal singapore 476
job part time job 401
career conversion programme 399
mid career switch 378
hire part time 369
career coach 357
singapore part time work 321
career path 293

However, because the data for the first keyword below is too large (as compared to the rest of the keywords), the data for the rest of the keywords looks very small in comparison.

Can someone advise how do I break the axis scale to allow the bars for the rest of the keywords look bigger?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-01-14T19:34:38+00:00

    That is not possible in Excel.

    As an alternative, you might set the horizontal (value) axis to use a logarithmic scale:

    0 comments No comments