![]() 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. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |