If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating a chart
Hello, I'm trying to create a chart that will mimic the candlestick chart but
it does not use a timeline. Instead of displaying the timeline along the X-axis, it will show the thickness of the sheet. Sample data available as follow : 1st data set: Thickness: 0.010 Min: 10 Max: 15 2nd data set: Thickness: 0.013 Min: 10 Max: 25 3rd data set: Thickness: 0.025 Min: 15 Max: 35 The chart will display the "Thickness" along the X-axis and the "Soak Range" (Min and Max) along the Y-axis. Microsoft Excel require several variable to create a stock chart, namely: Open, High, Low, & Close I have tried to mimic the candlestick chart by making the Y-axis (Soak range): Both "Open" and "Low" have the same value as "Min" Both "High" and "Close" have the same value as "Max" I was successful in my attempt for the "Soak Range" but the Thickness value shown along the X-axis is incorrect. It will display the number "1" "2" "3" instead of "0.010" "0.013" "0.025". How can I correct this? I'm using MS Excel 2002. Thanks, Devin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a chart | Luis | Using Forms | 0 | November 5th, 2004 10:13 AM |
Creating a dynamic chart for an engineering spreadsheet | Cal@tech-etch | Charts and Charting | 1 | November 3rd, 2004 07:50 PM |
Creating a combination chart using cluster column & stacked bar t. | hrussell | Charts and Charting | 1 | November 1st, 2004 12:08 AM |
Creating a chart based on filtered results | Stretch | Charts and Charting | 3 | September 10th, 2004 05:43 PM |