How to make a line graph in Excel 1. Open the Excel spreadsheet with the data you wish to use in your line graph. Make sure all of the data is correct. 2. Click and drag your cursor to highlight ...

Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to the format you prefer.

Here’s how you can add them to your Excel spreadsheet: Select your data range. Go to the Home tab. Click Conditional Formatting > Data Bars and pick a style ( Gradient Fill or Solid Fill ). Even with ...

By selecting all three columns of data, you can select the type of chart from Excel's Insert tab. The most useful selection is a bar chart, because it allows you to format the second series as a line.

How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

Choose a line chart with markers to represent monthly sales. The resulting chart shown in Figure D is a bit cluttered, but this article isn’t about formatting the chart, so try to ignore that.

Excel (2007) automagically grouped date and time on the X axis. Edit: I had time in the format of NN:NN. Excel doesn't know to combine date and time with a time format of NNNN.

Excel opens the new Conditional Formatting pane to the right. This pane is much easier to work with than the desktop interface. The Apply to Range is set to the range selected in step 1 by default.