Forum Discussion

ExcelGeek90's avatar
ExcelGeek90
Brass Contributor
Oct 17, 2024

Stack Graph Support

Hi everyone , 

 

In MC 1 I want to show blue region which is equal to value 2 as a gap. I mean I want to start MC1 graph/stack form 2 to onwards I mean only orrange zone.  I want to make blue disappear but don't let orange drop to zero . 

 

I want to start MC1 stack graph from 2 to onwards. 

 

Can anyone help?

  • ExcelGeek90 

    Click in the chart.

    Click on one of the blue bars. Both should be selected.

    (Do not click again, that would select a single bar).

    On the Format tab of the ribbon (to the right of the Chart Design tab), select Shape Fill > No Fill.

    If you still see the border, select Shape Outline > No Outline.

  • ExcelGeek90 

    Click in the chart.

    Click on one of the blue bars. Both should be selected.

    (Do not click again, that would select a single bar).

    On the Format tab of the ribbon (to the right of the Chart Design tab), select Shape Fill > No Fill.

    If you still see the border, select Shape Outline > No Outline.

Resources