how to make best fit line on excel for mac

Make Best Fit Line On Excel How To Do This
Make Best Fit Line On Excel Download This Sample

You like it, right Say Yes in the comment section if you like it.

OK so listen: Lets say you have an average value which you want to maintain in your sales throughout the year.

Or, a constant target which you want to show in a chart for all the months.

In this case, you can insert a straight horizontal line to present that value.

Heres the thing: This horizontal line can be a dynamic one which will change its value or a line with a fixed value.

Make Best Fit Line On Excel How To Do This

And in todays post, Im going to show you exactly how to do this.

Im gonna share with you that how you can insert a fixed as well as a dynamic horizontal line in a chart.

Add an Average Horizontal Line to a Chart An average line plays an important role whenever you have to study some trend lines and impact of different factors on trend.

And before you create a chart with a horizontal line you need to prepare data for it.

Before I tell you about these steps let me show how I am setting up the data.

Here I am using a dynamic chart to show you that how this will help you to make your presentation super cool.

In above data tables, I am getting data from raw table to the dynamic table by using a VLOOKUP MATCH.

Every time when I change the year in the dynamic table it will automatically change the sales values and the average will be calculated on those sale figures.

Steps to Add an Average Line Below are the steps you need to follow to create chart with an horizontal line.

First of all, select the data table and insert a column chart.

Next step is to change that average bars into a horizontal line.

For this, select the average column bar and Go to Design Type Change Chart Type.

Once you click on change chart type option, youll get a dialog box for formatting.

Change the chart type of average from Column Chart to Line Chart With Marker.

Make Best Fit Line On Excel Download This Sample

Click OK. Here is your ready to rock column chart with a average line and make sure to download this sample file from here.

One of my colleagues uses this same method to add a median line.

You can also use this method to add an average line in a line chart.

Steps are totally same, you just have to insert a line chart instead of a column chart.

Add a Horizontal Target Line in Column Chart This is one more method which I often use in my charts is adding a target line.

Achievement chart, but target line method is simple effective.

How To Make Best Fit Line On Excel For Mac