Fantastic Solid Line Border Chart Excel
In your graph double-click the target line.
Solid line border chart excel. Use the Border Color option to change the color of the. Gridlines are rarely utilized in a chart and should always be removed or marginalized. Instead of smooth lines in Excel there is a bad-looking dotted black grid.
You can follow the question or vote as helpful but you cannot reply to this thread. One of the elements you can change is the type of border Excel places around the legend. Expression A variable that represents a Border object.
Select color you can also edit or adjust other parameters like transparency or width. Format the line to be invisible. To change the appearance of the legends border follow these steps.
Removing such components will help the data being presented stand out to the viewer. This will select the line and open the Format Data Series pane on the right side of your Excel window. Then solid border is displayed.
Click the arrow besides Border button More Borders on the Home tab. How can I fix the grid in Excel. This thread is locked.
Still in Format Chart Area under Fill Line-Border check on Solid line. Change the chart type to a line chart with markers. Learn how to add a border to the legend of a graph in Microsoft ExcelTo add a border to a legend begin by selecting the legend on your graph and navigating.