Graph intra-day stock data

F

FIG

How do you graph intra day data (Date, Open, High, Low,
Close) format. Where the Date includes the time: (2/22/04
9:00 AM format). Currently, I get a chart with all the
individual 30 min bars being grouped into just a daily
bar, I would like individual bars for each half hour.
 
T

Tushar Mehta

The easiest way would be to use a XY Scatter chart, rather than a Line
chart.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Occasional meter readings chart 0
Graph usage for times of day 0
Outlier data point for Chart in Excel 1
Macros to convert Data into date format and then plot in graph 7
Excel 2007 Stock market Charts 3
How to show time for day's stock market high/low 13
Stock Charts Do Not Display Open and Close 0

Top