chart

[Guest]

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

 

[Andy Pope]

Hi,

Try the following data in range A1:E4.

Thick Min Max X
0.01 10 10 15 15
0.013 10 10 25 25
0.025 15 15 35 35

Select and create a stock OHLC chart ploting by columns.

Cheers
Andy

 

[Guest]

Hi Andy, I have tried what you said but the number "1" "2" "3" still show up
along the x-axis. I want it to display the thickness value (ie. .01, .013,
..025) instead.

How can I do it?

Thanks,

Devin

 

[Andy Pope]

See this example.
http://www.andypope.info/ngs/ng39.htm

Cheers
Andy