Graph Advice

[Simon Jelinek]

I am trying to create a graph similar to the stock graphs
in excel, i belive they are also known as candelstick
graphs. For data returning highest number of transactions
the time this took place, for the morning and the
afternoon,each day and this is to be displayed weekly. I
tried following the stock graphs but they did not like
the format of the data. any ideas how I can acheve this
or any alternative graphs.
24/5/2004 25/05/2004 26/05/2004
Time Max Time Max Time Max
A.M 10 24616 10 27203 7 28349
P.M 18 67645 18 78523 15 29295

Thanks in Advance

 

[Guest]

Ross

Thanks the websites were very handy but not exactly what
i was loking for.

Many thanks

Simon

 

[Tushar Mehta]

What do you want on the respective axes?

--
Regards,

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

 

[Jon Peltier]

Hi Simon -

A stock chart expects the data in a certain order: Open-High-Low-Close.
The up-down bars go from the first to last series, and the high-low
lines connect the extremes.

Looking quickly at your data, I'm not sure I see how you were going to
coerce a fit to such a chart. What might make sense is to rearrange your
data:

AM PM
5/24/2004 24616 67645
5/25/2004 27203 78523
5/26/2004 28349 29295

Make a line chart, then double click on one of the series, and on the
options tab, experiment with the various hi-low/up-down settings.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[simon jelinek]

Thanks for your help

Simon

-----Original Message-----
Hi Simon -

A stock chart expects the data in a certain order: Open- High-Low-Close.
The up-down bars go from the first to last series, and the high-low
lines connect the extremes.

Looking quickly at your data, I'm not sure I see how you were going to
coerce a fit to such a chart. What might make sense is to rearrange your
data:

AM PM
5/24/2004 24616 67645
5/25/2004 27203 78523
5/26/2004 28349 29295

Make a line chart, then double click on one of the series, and on the
options tab, experiment with the various hi-low/up-down settings.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______



.