Changing color of connector lines in a waterfall chart for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1031628%22%20slang%3D%22en-US%22%3EChanging%20color%20of%20connector%20lines%20in%20a%20waterfall%20chart%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1031628%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20assembling%20a%20waterfall%20chart%20in%20Excel%20for%20Mac%20and%20I%20want%20dark%2C%20visible%20connector%20lines.%20However%2C%20when%20I%20highlight%20the%20connector%20lines%20I%20can't%20separate%20them%20from%20the%20border%20around%20the%20bars%20in%20the%20chart.%20This%20means%20when%20I%20make%20the%20connector%20lines%20dark%2C%20the%20borders%20of%20the%20bars%20in%20the%20chart%20turn%20black%20too-%20which%20I%20don't%20want.%20Can%20anyone%20explain%20how%20to%20separately%20change%20the%20color%20of%20the%20connector%20lines%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1031628%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1031805%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20color%20of%20connector%20lines%20in%20a%20waterfall%20chart%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1031805%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Right-click%20on%20the%20connector%20line%20and%20select%20Format%20Data%20Series%3CBR%20%2F%3E2.%20Under%20the%20series%20options%2C%20select%20Fill%20%26amp%3B%20Line%3CBR%20%2F%3E3.%20Select%20Fill%3CBR%20%2F%3E4.%20Select%20desires%20color%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20change%20the%20Border%20line%20color%3CBR%20%2F%3ESelect%20Border%20and%20select%20preferred%20color%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am assembling a waterfall chart in Excel for Mac and I want dark, visible connector lines. However, when I highlight the connector lines I can't separate them from the border around the bars in the chart. This means when I make the connector lines dark, the borders of the bars in the chart turn black too- which I don't want. Can anyone explain how to separately change the color of the connector lines? Thanks!

2 Replies
Hello,

1. Right-click on the connector line and select Format Data Series
2. Under the series options, select Fill & Line
3. Select Fill
4. Select desires color

To change the Border line color
Select Border and select preferred color

@Abiola1 That changes the border lines of the data - not the connector lines. We need to have no lines around the data but connector lines on a different-than-default background color. That's the problem.