Instructions cover Excel 2019, 2016, 2013, 2010, and Excel for Microsoft 365.
Enter the data in cellsA1toC6.
Highlight the data, including row and column headings.
tap on theInserttab of theribbon.
Hover your mouse pointer over a chart jot down to read a description.
The chart will appear on your spreadsheet.
Click and hold to move the chart to the right, away from the data table.
Click once on the default chart title to select it.
A box should appear around the wordsChart Title.
Click a second time to put Excel in edit mode, which places the cursor inside the title box.
Delete the default text using theDeleteorBackspacekeys on the keyboard.
Enter the chart title into the title box.
Click next to the chart title to pick the entire graph.
Click theFormattab of the ribbon.
Click theShape Filloption to initiate the Fill Colors drop-down panel.
Choose a color, texture, gradient, or texture to fill the background.
Stay on theFormattab and click theText Filloption to kick off the Text Colors drop-down list.
Choose the color you want to use.
All the text in the title, x- and y-axes, and legend should change.
you could change the color for each line in the graph individually.
Click once on a line to select it.
Small highlights should appear along the length of the line.
On theFormattab click theFormat Selectionoption to launch the Formatting task pane.
Then click theFill icon(the paint can) in the task pane to launch the Line options list.
hit the color you want to use for the line.
Repeat for the other lines, if desired.
They do not, however, need to be quite so prominently displayed.
One easy way to tone them down is to adjust their transparency using the Formatting Task pane.
press theFormat Selectionoption on the Format tab of the ribbon to bring up the Formatting Task pane.
In the graph, click once on one of the horizontal gridlines running through the middle of the graph.
There should then be blue dots at the end of each gridline.
In the pane change the transparency level to75% the gridlines on the graph should fade significantly.
All of these parts are considered separate objects by the program so that you might format them separately.
If you make a mistake, it can be quickly corrected using Excel’sundo feature.
Then, grab the correct part of the chart and take another crack.
