Graph intra-day stock data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FIG - 15 Feb 2004 11:50 GMT

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.

Reply to this Message

Tushar Mehta - 15 Feb 2004 13:51 GMT

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

Signature

Regards,

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

> 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.

Reply to this Message