How can I partially change the scale of the axis?

[Thanos]

Hi,

I am wondering if I can change the scale of one of the axis on a chart in order to interpret better my data.
There is this packed part of my data which are concetrated on the y-axis and then some random data at random places on my chart. To be more specific the x-axis represents the contribution of each product to the total revenue and the y-axis represents the gross margin of each product.
Vast majority of the products contribute less than 1% of the total revenue and as a result I see plenty of them being packed on the y-axis of my scatter plot.
Ideally, I would like to rescale the x-axis in a way where the first half will be among 0% and 2% and the rest among 2% and 15%. This will help the reader of the chart to understand better the graph since the data will be more spread.
Please find attached the file.
Many thanks in advance.

 

[Hui]

Thanos
Use Two chart positioned side by side
Adjust first chart X-Axis to go from 0-0.02 and second to go from 0.02-0.15
The remove Y Axis from second chart
set background to Transparent = None
Then adjust locations so they are next to each other
Voila

See attached file

 

[Thanos]

Merci beaucoup Hui.
Your help is priceless (for second consecutive time) ;-)
I was hoping that excel does it on its own but anyhow.
In Greece we call these kind of solutions ''alchemies'' coz we simply find a ''do it your self'' method since there is no projected solution.
Have a nice day!