Adding Volume to a Candlestick Chart in Excel 2007:-


Excel offers a built-in chart you can use to create a candlestick chart with volume bars. As with the volume-high-low-close chart, the height of the volume bars is often too large. You follow these steps to create a chart based on the built-in volume-open-high-low-close chart type:

1. Download data from Yahoo finance. Save the data as an Excel 2007 workbook. Insert a new column B before the Open column. Move the Volume data from column G to the new column B. Delete column G. Your data will be in the correct sequence, with Date in column A, Volume in column B, Open in column C, High in column D, Low in column E, and Close in column F.

2. Remove the Date heading from cell A1.

3. Select your data in columns A;F.

4. On the Insert ribbon, select Other Charts, Stock, Volume-Open-High-Low-Close. This is the fourth stock chart thumbnail. Excel creates the top chart in the Figure (given below).



(The top chart shows the default chart created in step 4.The bottom chart shows the result of the remaining formatting.)

5. Right-click the numbers along the left vertical axis and choose Format Axis. Specify a fixed maximum value that is about double the original amount. Choose Major Tick Mark Type, None. Choose Axis Labels, None.

6. On the Layout ribbon, choose Legend, None.

7. Choose Chart Title, Above Chart. Type the title GOOG 2006 and press Enter.

8. Right-click the labels along the horizontal axis. Choose Format Axis. On the Number tab, specify the custom formatting code mmmmm.

9. Reduce the horizontal size of the chart.