Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel trendline

ResolvedVersion Standard

Hellena has attended:
Excel Introduction course
Excel Intermediate course

Excel - Trendline

Can someone help with the explanation of trendlines - why it is used

RE: Excel - Trendline

Hi Hellena,

Thank you for your question.

If for example you have a chart showing a downward trend, and wanted to do a forecast to see where you would be at the end of the month if things continued at the historical rate, a trendline would be able to help.

The Add Trendline works if the series range is set up for a set period of time, with the remaining days in the series being blank. If your data series does not contain any blank cells for future days, then you use the Options tab of the Trendline dialog. On the Options tab, you can specify that the trendline should forecast forward any number of periods.

Past results may not be the perfect indicator of future results, but it can help you see if you are on the right track, which is one of the main uses of a trendline.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.

Have a great day.

Regards,

Nicole.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.