How to insert horizontal lines in word 2007

HOW TO INSERT HORIZONTAL LINES IN WORD 2007 HOW TO
HOW TO INSERT HORIZONTAL LINES IN WORD 2007 DOWNLOAD

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

Change the chart type of average from вЂњColumn ChartвЂќ to вЂњLine Chart With MarkerвЂќ.

Once you click on change chart type option, youвЂ™ll get a dialog box for formatting.

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

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

So now, you have a column chart in your worksheet like below.

or you can also use Alt + F1 to insert a chart.

Go To Insert вћњ Charts вћњ Column Charts вћњ 2D Clustered Column Chart.

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

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.Д«elow are the steps you need to follow to create a chart with a horizontal line. In the above data tables, I am getting data from the raw table to the dynamic table by using a VLOOKUP MATCH. (download this dynamic data table from here) to follow along. Here I am using a dynamic chart to show you that how this will help you to make your presentation super cool. And before you create a chart with a horizontal line you need to prepare data for it.Д«efore I tell you about these steps let me show how I am setting up the data. Add an Average Line to a ChartДЄnВ average line plays an important role whenever you have to study some trend lines and the impact of different factors on-trend. IвЂ™m gonna share with you that how you can insert a fixed as well as a dynamic horizontal line in a chart.

HOW TO INSERT HORIZONTAL LINES IN WORD 2007 HOW TO

And in todayвЂ™s post, IвЂ™m going to show you exactly how to do this. HereвЂ™s the thing: This horizontal line can be a dynamic one that will change its value or a line with a fixed value. In this case, you can insert a straight horizontal line to present that value. Or, a constant target which you want to show in a chart for all the months. OK so listen: LetвЂ™s say you have an average value which you want to maintain in your sales throughout the year.

You like it, right? Say вЂњYesвЂќ in the comment section if you like it.

How to insert horizontal lines in word 2007