Histogram, secondary axis, overlap
Solved
sygmajf99
Posted messages
18
Status
Membre
-
RedBubbles Posted messages 3 Status Membre -
RedBubbles Posted messages 3 Status Membre -
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,
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 réponses
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 ♂
With my thanks to sygmajf99.
--
Retirement is nice! Especially in the Caribbean ... :-)
☻ Raymond ♂
RedBubbles
Posted messages
3
Status
Membre
Thank you for this solution!
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
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