How can i create a worksheet with an upper and a lower chart? Like the
Bloomberg Charts. Upper chart with date, open, high, low and close. Lower
chart with other indicator.

Thanks

Probably easiest to create 2 charts and align and format them to look like
one. See
Stacked Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"pb" wrote:

How can i create a worksheet with an upper and a lower chart? Like the
Bloomberg Charts. Upper chart with date, open, high, low and close. Lower
chart with other indicator.

Thanks

That's easier, sure. But the alignment is difficult to maintain, as axis
labels increase or decrease in displayed digits and as other things change.

I've had good luck with "layered" or "stacked" regions in a single chart.
They may be harder to set up, but they are easier to keep aligned, because
one axis fits the whole chart. Here's a simple example:

http://peltiertech.com/Excel/Charts/StackedCharts.html

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

"Tushar Mehta" wrote in message
...
Probably easiest to create 2 charts and align and format them to look like
one. See
Stacked Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"pb" wrote:

How can i create a worksheet with an upper and a lower chart? Like the
Bloomberg Charts. Upper chart with date, open, high, low and close. Lower
chart with other indicator.

Thanks