Excel Stacked Bar Graph Query - How to remove a thin gap

[Pavan Dipak Girjapure]

Hello All,

Thank you for your time and help. I am new here and need your help.

I used Excel 2007 Stacked Bar chart & Shape to create the below graph.
As you can see there is this thin line between Stack1 and Stack2 Data Series.

PFA "Graph Query.xlsx"

How can I remove this gap?

Your help will be greatly appreciated!



Thanks and regards,

Pavan G

 

[vletm]

Pavan Dipak Girjapure
... linked Data Source ... hmm ... okay?
Is this better?

 

[Pavan Dipak Girjapure]

Pavan Dipak Girjapure
... linked Data Source ... hmm ... okay?
Is this better?

Thank you vletm,

I just wanted to get rid of the gaps.
I am looking for this result:



I followed this youtube video but getting a gap.

Appreciate your help!

 

[NARAYANK991]

Hi Pavan ,

Format the plot area to a dark color such as black , and use a light color such as orange for the bars.

Narayan

 

[vletm]

Pavan Dipak Girjapure
Your 'Flowchart: Delay 2"-picture has 'white' frames 'shadow' around...
take those away.

 

[Pavan Dipak Girjapure]

Pavan Dipak Girjapure
Your 'Flowchart: Delay 2"-picture has 'white' frames 'shadow' around...
take those away.

vletm, it is still not working. I removed the shadow around the shape. The gap is still there.

Thank you for your quick reply.

 

[Pavan Dipak Girjapure]

Hi Pavan ,

Format the plot area to a dark color such as black , and use a light color such as orange for the bars.

Narayan

Thanks for the suggestion. The gap is still there.

 

[Pavan Dipak Girjapure]

Pavan Dipak Girjapure
Your 'Flowchart: Delay 2"-picture has 'white' frames 'shadow' around...
take those away.

I will highly appreciate if you can make this change in the attached worksheet.
This will be very useful for my info-graphics project.

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[vletm]

Pavan Dipak Girjapure
Is 'what You see what You get'?
If You 'zoom' You sheet to 150% and
if You change 'Stack2' values to ex 145
and You set 'Stack1' line's correct color ...
then
those 'white lines' has gone ...

 

[Pavan Dipak Girjapure]

Pavan Dipak Girjapure
Is 'what You see what You get'?
If You 'zoom' You sheet to 150% and
if You change 'Stack2' values to ex 145
and You set 'Stack1' line's correct color ...
then
those 'white lines' has gone ...

It worked!!!!!! Thanks a ton sir. You are a star. Superliked.

 

[JT2023]

2023
Same problem after watching the same video but I don't understand the explanation. Excel 2019 here. Can someone help please ?
Thank you

 

[vletm]

JT2023
... continue reading from #10 reply.
If You'll still has any challenges then please open a new thread with Your sample file.