Thread: 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

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

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
>

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