How to Make a Scatterplot on Excel. A scatterplot chart graphs two related data values as a single dot by plotting one value on the horizontal X axis and the other value on the vertical Y axis ...

Microsoft Excel 2010 does not plot hidden rows or columns, so you need to hide the empty rows or columns. Strangely, in Excel 2010, unhiding the data is easier than hiding it.

Building a Robust Regression Model in Excel To begin your regression analysis journey in Excel, start by plotting your sales data against potential predictor variables, such as rainfall data.

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.