Lesson#54: Charting practice with stock data
Let’s have some charting practice in excel. I have downloaded last month’s INFOSYS stock data from the National Stock Exchange website in CSV format.
Now I will go to Insert>Charts>Other Charts>Stock>Volume-Open-High-Low-Close
So I have arranged the data table in that order and selected five columns thenĀ Insert>Charts>Other Charts>Stock>Volume-Open-High-Low-Close
Then the chart will appear as it has shown in the picture above.
But it has to be changed a little. Date values should be shown on X-axis. For that right click on the chart, click on select data, Click Edit below Horizontal (Category) Axis Labels, and select the values under Date
You can change the design of the chart from Chart Tools> Design
Or you can change the layout of the chart from Chart Tools> Chart Layouts
Leave a Reply