Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Plot lines between plot points on a line chart JDKapono24 Charts and Charting in Excel 2 April 2nd 23 07:07 PM
Vertical lines in Excel Chart dsears Charts and Charting in Excel 2 April 21st 09 04:58 PM
Bar chart turns to vertical lines Dvanwig Excel Discussion (Misc queries) 3 July 3rd 07 03:46 AM
XY Scatter Plot Chart - URGENT HELP Kanky Charts and Charting in Excel 1 May 11th 06 10:30 AM
Vertical Lines on the Lines on 2 Axes Chart [email protected] Charts and Charting in Excel 3 March 3rd 06 04:14 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"