Forum Discussion

Akers10's avatar
Akers10
Copper Contributor
Nov 25, 2019

Changing color of connector lines in a waterfall chart for Mac

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!

  • ScottJBrown's avatar
    ScottJBrown
    Copper Contributor

    Hi Akers10 

    While this thread is old, I am providing a response as this information may be useful to others in the future.

     

    Changing connector line color is not natively supported. To allow for customization of chart appearance to meet varying user requirements, individual chart components or elements would need to have separate property sets.

     

    I used a Stacked Waterfall Chart for this purpose and have included a link to a how-to video. This solution is made possible by the availability of component-specific properties.

     

    Thanks

  • cg1847's avatar
    cg1847
    Copper Contributor

    Akers10 

    As far as I can tell, there's no native support, but here's my workaround (all lines are the same).

    1. Click the entire data series (all bars / lines should be highlighted)

    2. Change the fill / line settings to what you want the connector lines to be

    3. Double-click one of the bars

    4. Change the fill / line settings back to what you want that bar to be

    5. Repeat for all bars

  • 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
    • ToesInTheSand's avatar
      ToesInTheSand
      Copper Contributor

      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.

Resources