ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Urgent Help - Plot Quartiles as vertical lines in Chart (https://www.excelbanter.com/charts-charting-excel/251210-urgent-help-plot-quartiles-vertical-lines-chart.html)

TAlgo

Urgent Help - Plot Quartiles as vertical lines in Chart
 
All,

Sorry but need some quick help in this project. I was told to create a
quartile chart for last one year of closing price of Soybean
Commodity. I am going to paste small data set here. Can someone please
guide how to show quartiles as vertical lines in a chart?

Also someone please suggest what should be X axis and Y axis values
here?
Date Close Price
1/1/2009 38.36 Quartile 1 60.7825
1/2/2009 43.4 Quartile 2 67.27
1/3/2009 45.34 Quartile 3 76.9675
1/4/2009 46.49
1/5/2009 49.12
1/6/2009 49.5
1/7/2009 50.5
1/8/2009 51.13
1/9/2009 51.8
1/10/2009 51.86
1/11/2009 51.91
1/12/2009 51.97
1/13/2009 52.44
1/14/2009 52.76
1/15/2009 53.06
1/16/2009 53.36
1/17/2009 53.47
1/18/2009 53.6
1/19/2009 53.63
1/20/2009 53.67
1/21/2009 53.7




All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com