How to align x axis label of 2 charts

[Nigel99]

I created 2 charts ( 1 is line chart and another one is line and stacked column chart) and would like to put them on top of each other. They are sharing same x axis label which is categorical variable. How would I manage to accomplish? The x axis label of line chart seem to be offset a bit.

[Nigel99]

I would replicate the doubt using excel charts. I am trying to stack the line chart (front) and bar chart (back) of same width and height on Power BI. The x axis label seem to be switched i.e. "John" of line chart is not align with "John" of bar chart. I was expecting to see they are overlapping on each other. 

[Ritaf1983 · Accepted solution]

Ok, then my previous answer was right, 
Different graph types have different proportions .....

Excel is much more flexible, you can modify almost every pixel of the graphs, but Power BI is unfortunately not there yet...

So check other options to reach the desired goal, 
back to the beginning of the discussion for boxplot, you can use error bars.

https://www.youtube.com/watch?v=u6JVQKj5ijU

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983]

Hi @Nigel99 
Can you show please  what are you trying to do?

[Nigel99]

My apology for not able to sharing due to confidentiality. That being said, I was trying to place one chart (with transparent background) on top of another. My intention is to achieve boxplot. 

1. Line chart - display all data point including outliers

2. Line chart and stacked column chart - display Q1, Q2, Q3 etc

Both charts are sharing same categorical variable on x-axis. Upon combining, one of chart x axis label seem to shift, making both xaxis label not align.

[Ritaf1983]

Hi @Nigel99 

Not sure I understood the description correctly, but I'll try to guess 🙂

If the intention is to arrange proportions in 2 different types of graphs (line chart and combo chart it is not the same graph )that will be 100% identical, regardless of the distance between bars/points on the graph, we do not have any customization options.

Regarding box plots, try to see if the attached video link can help:

https://www.youtube.com/watch?v=u6JVQKj5ijU

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Nigel99]

Not identical though. The label is the same; the top one is not aligning with the one beneath.

[Ritaf1983]

The label doesn't matter this is a "proportions" question...
Different graph types have different proportions .....

[Nigel99]

Ohh I see...Meaning to say, no customisation setting to sort this out.?

[Ritaf1983]

Maybe I still didn't understand what you were trying to do.

Are you trying to sort the axes in the same order, or is there a problem where the same point doesn't appear exactly below the other in the two graphs?
It is very difficult to talk about and assist with visual topics based on words alone... I recommend again preparing a small example of what you are trying to accomplish. This will make it much easier for those who are trying to help.