Bar chart - Remove space between bars (data input from >2 lines/cells)

[Luckkie]

Hi there! I'm looking for a way to remove space between bars that are generated from more than two different cells. Does anyone know a way to do this?

Firstly, I'll give some more information.

I've got data from 2022, with percentages related to different values. The different values could be <10, >10, >100, >1000 and >10000. I'm displaying these values in gray.

Then, I've got 2023, which (till now) only provides data from the following values: <10, >10 and >1000. I want to display <10 in green, >10 in orange and >1000 in red. Therefore, I made different lines. However, I can't figure out how to remove the space between the lines. Ideally, there's should be no space between the bars from 2023 and 2022.

(Some other reasoning for this case is that I want to show what the different bars are 'in the graph', (to show which color is which parameter), therefore I have to use the method described above).

Kind regards!

 

[awoohaw]

can you post an image of what you have now for the chart?
Can you aslo use the xl2bb add in to post the data series data (link below), or at least post the data in a table.
The forum needs to manually recreate your scenario and they may make errors or typos, in addition to not fully understanding your question and provide a solution that may work, but not be the solution you seek. Help the forum help you.

 

[awoohaw]

so, not really sure what you mean when you wrote "lines" when you started talking about column/bar charts. But here is a column chart with no gap between the series:

 

[awoohaw]

Here it is with the colors you specified for 2023 and no data for >1000, >10000. and No gaps between series groups as well.

 

[awoohaw]

Here is the last post as a bar chart, and with Percent formatting:

 

[Luckkie]

can you post an image of what you have now for the chart?
Can you aslo use the xl2bb add in to post the data series data (link below), or at least post the data in a table.
The forum needs to manually recreate your scenario and they may make errors or typos, in addition to not fully understanding your question and provide a solution that may work, but not be the solution you seek. Help the forum help you.

I'm sorry, but I'm not sure what xl2dd is.

Either way, I'll provide two images of my options. The first one's what I'm currently strugling with (regarding the space between bars from different data input). The second one is my other option. (This is almost the same as your last picture). However, the color of '2023' on the side of the graph does only match with one of the bars and therefore I'd prefer the first option (I think).

 

[Luckkie]

(1. I've put the bar width on 0% already)

 

[Luckkie]

2.

 

[awoohaw]

this is the xl2bb add in: https://www.mrexcel.com/board/mrexcel-xl2bb.svg

i'm not sure why you want to treat the 2023 data as unique data series.

 

[Luckkie]

this is the xl2bb add in: https://www.mrexcel.com/board/mrexcel-xl2bb.svg

i'm not sure why you want to treat the 2023 data as unique data series.

Alright thanks for that.

I did that because in the second graph (2nd picture) it looks like the 2023 data is green only, while it contains the orange and red bar as well.