View original (French)

Histogram, secondary axis, overlap

Solved
sygmajf99 Posted messages 18 Status Member -  
RedBubbles Posted messages 3 Status Member -
Hello,

I am using Excel 2007.

I created a histogram with a secondary axis for the y.

The problem is that the bars overlap, meaning they are one on top of the other. I would like them to be side by side. I tried playing with the % of overlap, and nothing works.

The only solution I found is to create a second separate histogram, with no fill, and paste it on top of the first one. Visually, it looks nice, but I don't find it optimal.

Does anyone have a better solution?

Thank you,

3 answers

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    One year later ... https://forums.commentcamarche.net/forum/affich-37641881-excel-histogrammes-accoles-echelles-differentes

    With my thanks to sygmajf99.

    --
    Retirement is nice! Especially in the Caribbean ... :-)
    ☻ Raymond ♂
    11
    1. RedBubbles Posted messages 3 Status Member
       
      Thank you for this solution!
      0
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Can we have the file?
    --
    Retirement is nice! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    4
    1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      I tried a bit of tinkering:
      We have the x-coordinates in A, the two series in B and C.
      * insert an empty column after column B;
      * assign the secondary axis to the shifted series in D;
      * set the first series to overlap series at -100% (separate) and the interval width to 0% (no interval);
      * for the third series, set the interval width to 200%.

      https://www.cjoint.com/?BCBa2VAKygt
      0
    2. jbtov Posted messages 4 Status Member 100
       
      Thank you very much, Raymond!!
      0
    3. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      This makeshift solution, which ultimately isn't one, also helped out a friend.
      Maybe I'll make a technical sheet for it...
      0
    4. ad
       
      Top thanks.
      0
  3. Micracra
     
    Thank you very much, this tutorial is great :) !!
    0