The bar chart below is what I have at the moment. As you see there is a huge difference between the y-values. I could use a logarithmic x-axis, but this is not readable for non-scientists.
I want to make the x-area between 0 and 500 twice as big and the rest shrinks accordingly. How do I change the distribution on an axis?
I hope you understand what I mean, it is difficult for me to explain it.

edit: I tried to apply the answer of this question Axis break in pgfplots but unfortunatelly i wasn't able to do it with bar charts.
\documentclass[]{article}
\usepackage{pgfplots}
\usepackage{pgfplotstable}
\begin{document}
\title{Title}
\author{Author}
\date{Today}
\maketitle
\pgfplotsset{width=15cm, compat=4}
\begin{tikzpicture}
\begin{axis}[xbar stacked, nodes near coords,
xbar=30pt,
bar width=5,
xmajorgrids = true,
yticklabel style={/pgf/number format/1000 sep=,font=\tiny},
ytick=data,
bar width= .2cm,
nodes near coords align = {horizontal},
nodes near coords,
nodes near coords align=right,
every node near coord/.style={color=black,font=\tiny}
]
\addplot[draw=green,fill=green!50,enlargelimits=0.25]
coordinates{
(3133,1) (731,2) (1196,3) (273,4) (83,5) (312,6) (40,7) (36,8) (76,9) (15,10) (8,11) (38,12) (9,13) (7,14) (20,15) (3,16) (2,17) (13,18)
(2,19) (4,20) (3,21) (2,22) (2,23) (2,24) (1,26) (1,27) (1,28) (1,30) (2,31) (2,33) (1,35) (1,36)
};
\end{axis}
\end{tikzpicture}
\end{document}

