There is no premade chart to do this.
YOu will need to calculate the medians on a worksheet and plot them yourself.
"Nitin Gupta" wrote:
I want to create a line chart showing the trend of MEDIAN value in Excel. The
medain value is calculated for a range of cells in the sheet.
I am not able to see the option for this kind of chart in Insert-Chart menu.
|