|
|
See this example.
http://www.andypope.info/ngs/ng39.htm
Cheers
Andy
Devin wrote:
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" wrote:
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
Devin wrote:
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, Microsoft MVP - Excel
http://www.andypope.info
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
|