Formatting Excel Sparklines

Formatting Excel Sparklines In the last lesson, you saw how to add a Sparkline to a cell. In this lesson, you'll learn how to format your Sparklines. You can liven up your Sparklines by clicking on the Design ribbon at the top of Excel. You'll then see five panels: Sparkline, Type, Show, Style, and Group. To add markers to your...

Read More

Sparklines in Microsoft Excel

Sparklines in Microsoft Excel Sparklines are mini graphs that you can add to cells in your spreadsheet. They were introduced in Excel 2010, and look like this: The graph in the cell A8 shows the scores that Lisa achieved in her tests. You can quickly see that Lisa's scores are going up all the time, with no dips. To add Sparklines to your...

Read More

Extending the Trendline in Microsoft Excel

Extending the Trendline in Microsoft Excel In the first part of this tutorial you saw how to add a Trendline Chart. The type of Trendline we used was an Linear Regression one. You can get Excel to extend the linear regression line on your chart. Click on your chart to highlight it. Click on the plus symbol again (Or bring up the Format...

Read More

Predicting future values with Excel Charts

Predicting future values with Excel Charts Excel can help you make predictions about future values, or help you spot a linear trend. What we'll do in this section is set up something called a Trendline. We'll use an X, Y Scatter chart for this. We'll take a look at future income predictions based on what was earned in previous years. If you're a...

Read More

Format Axis Titles in Microsoft Excel

Format Axis Titles in Microsoft Excel From the previous lesson, your 2D Excel Line Chart should look like this: To format the dates on the bottom Axis, click on them with your left mouse button. With the dates Axis selected, right click. You should see this menu: Select Format Axis from the menu, and you'll see the following...

Read More