Add Or Remove Series Lines Drop Lines. If you are using Excel 2010 or earlier versions please click the chart to activate the Chart Tools and then click Layout Lines Drop Lines. As you can see in the screenshot above applying the white background will give an effect of hidden gridlines in your worksheet.
Select the drop-down arrow and choose Line. If playback doesnt begin shortly try restarting your device. Go to the Font group on the HOME tab and open the Fill Color drop-down list.
Right click on the sales and profit axis and unselect show header.
Change the alignment to center top and the color to. Right click on the sales and profit axis and unselect show header. Double click on the series to bring up the Format Series dialog. If you prefer to drop rather than slice you could use the built-in drop method.