Solved

# How to mark minimun, maximun, average values of the data on a chart?

Posted on 2015-01-28
95 Views
I have a set of data and a line chart associated with it. How to mark the min, max and averge with horizonal lines on the chart?
0
Question by:jfz2004
1 Comment

LVL 25

Accepted Solution

ProfessorJimJam earned 500 total points
ID: 40575191
This is not a blind link,  see if this is what you are looking for

http://www.agentjim.com/mvp/excel/Charts/MaxMin2013/Average_Value_Chart_in_Excel_2013.html
0

## Featured Post

### Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.