If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

Line Charts: Best for displaying trends over time or continuous data. Use when you have a series of data points connected by straight line segments. Pie Charts: Suitable for showing parts of a whole.

If you wish to calculate CPI in Excel and create its graph, please read through this article. Note: While creating this article, we are assuming the purchased quantity of products to be constant.

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.

You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis. Each point will then be plotted as a ...

I just tried this. Select all the data you want to have graphed, click on Insert, pick line graph, and choose which one you want. Excel (2007) automagically grouped date and time on the X axis.

Related coverage from How To Do Everything: Tech: How to make a line graph in Microsoft Excel in 4 simple steps using data in your spreadsheet How to add a column in Microsoft Excel in 2 different ...