Excel construct single chart from 2 charts

Hello All, Anyone an idea how to construct such a chart in Excel?

http://chart.yahoo.com/c/5y/p/pdli.gif

I know you can build more then one chart into one chart sheet but what
i really want to do is construct one chart or 2 chart objects
assembled into 1 so they can be exported into 1 gif as per above

looked at the charting samples at the John Peltier site but still got
no idea how to construct this

TIA
Brian

Brian -

The way I've done this is by embedding two chart objects in a blank
chart sheet. A little VBA to make sure the chart axes line up. Then the
chart sheet is exported.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Brian wrote:

> Hello All, Anyone an idea how to construct such a chart in Excel?
>
> http://chart.yahoo.com/c/5y/p/pdli.gif
>
> I know you can build more then one chart into one chart sheet but what
> i really want to do is construct one chart or 2 chart objects
> assembled into 1 so they can be exported into 1 gif as per above
>
> looked at the charting samples at the John Peltier site but still got
> no idea how to construct this
>
> TIA
> Brian

Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:<#zEI8yL8DHA.632@TK2MSFTNGP12.phx.gbl>...

> embedding two chart objects in a blank chart sheet. A little VBA to make sure the chart axes line up. Then the chart sheet is exported.

unbelievable!

it was the first time i actually exported it from the chart sheet.
when you try to save it as html it produced 2 gifs that's why i didn't
even try it

exporting the complete sheet to gif worked like a charm, with some vba
and the help of powerpoint i can resize the thing

thanks a lot Jon

Brian

Brian -

The Save As HTML option has been frustrating to me since it came out. So
I always export the charts this way, and do my tables in a text editor,
because that's how I control what I get.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Brian wrote:

> Jon Peltier <jonxlmvpNO@SPAMpeltiertech.com> wrote in message news:<#zEI8yL8DHA.632@TK2MSFTNGP12.phx.gbl>...
>
>
>>embedding two chart objects in a blank chart sheet. A little VBA to make sure the chart axes line up. Then the chart sheet is exported.
>
>
> unbelievable!
>
> it was the first time i actually exported it from the chart sheet.
> when you try to save it as html it produced 2 gifs that's why i didn't
> even try it
>
> exporting the complete sheet to gif worked like a charm, with some vba
> and the help of powerpoint i can resize the thing
>
> thanks a lot Jon
>
> Brian