![]() To highlight maximum and minimum values in the excel line chart, we need to add two supporting columns. I want to have a line graph that highlights the top sales and bottom sales in the year.ġ: Add Supporting Columns for Max and Min Values Here I have a data set of sales of different months of a year in Excel Table. How to Highlight Max and Min on Excel Line Graph In this article, we will learn how to highlight the top and bottom values on excel Line charts and Column Chart both. It is always a good idea to highlight the key values on the graph so that the max and min values can easily be spotted visually. But in line and column Excel charts, it often gets difficult to identify, which value is highest and which value is lowest. Knowing the highest and lowest value in a data set is essential in almost all kind of reports. As they say, a picture worths a thousand words, this is true in all fields.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |