Bigger Candles in Candlestick Charts

Expiry

Well-known Member

Joined

Jun 20, 2007

Messages

865

• Apr 3, 2008

• #2

I've never been asked to make anyone's candle bigger, before.

 

Upvote 0

A

avinashraste

Board Regular

Joined

Mar 12, 2008

Messages

167

• Apr 3, 2008

• #3

Dear Expiry,

Suggest a solution if you can.

Avinash Raste

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Apr 3, 2008

• #4

Can you adjust the y axis scale?

 

Upvote 0

Gerald Higgins

Well-known Member

Joined

Mar 26, 2007

Messages

9,258

• Apr 3, 2008

• #5

Expiry, Sumeaadw !

 

Upvote 0

Expiry

Well-known Member

Joined

Jun 20, 2007

Messages

865

• Apr 3, 2008

• #6

avinashraste said:

Dear Expiry,

Suggest a solution if you can.

Avinash Raste

Click to expand...

Avinash, chill out man. A little humour helps us all get through the day and a courteous request often gets more help than an abrupt one.

To answer your question, surely the only way you can do this is to change the scale on the Y axis, as suggested. The chart represents the figures you have, so if the movement is small, the candle will be.

 

Upvote 0

A

avinashraste

Board Regular

Joined

Mar 12, 2008

Messages

167

• Apr 4, 2008

• #7

Dear All,

First of I'm so sorry for replying late as internet connection was bad yesterday.

Thank you very very much for sparing time & help & solving my problem. It is solved immidiately after I read the post by Andrew Sir & Expiry Sir.

And yes, you are absolutely right Expiry, a small humour is always advisable for a great day...I take it very rightly. Thanks onc again all of you for help.

Thanks & Regards

Avinash Raste

 

Upvote 0

J

Jon Peltier

MrExcel MVP

Joined

May 14, 2003

Messages

5,318

Office Version

1. 365

Platform

1. Windows
2. MacOS

• Apr 5, 2008

• #8

avinashraste said:

Dear All,

I'm having a problem in making a Candlestick chart in excel. Candlestick chart is used for stock charting. When a price range is too narrow for some days, the candles are very small to judge & see even.

Can anyone suggest a solution to make the candles bigger without making the Full screen chart. That means Normal chart with bigger candles.

Thanks & Regards

Avinash Raste

Click to expand...

As an option, I often use tick marks to denote open and close. When the values are close together it's easier to see which is somewhat greater than the other. It also looks more like the NY Times charts. Here's a tutorial which should help:

http://peltiertech.com/Excel/ChartsHowTo/StockChartsAndLineChartTricks.html

If you are absolutely stuck with candlesticks, you could format the up and down bars so that they only have a fill color and no border, or so the border matches the fill.

 

Upvote 0