Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
Vertical lines in Excel Chart | Charts and Charting in Excel | |||
Bar chart turns to vertical lines | Excel Discussion (Misc queries) | |||
XY Scatter Plot Chart - URGENT HELP | Charts and Charting in Excel | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel |