Excel construct single chart from 2 charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 11 Feb 2004 09:58 GMT

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

Reply to this Message

Jon Peltier - 11 Feb 2004 16:33 GMT

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/
_______

> Hello All, Anyone an idea how to construct such a chart in Excel?
>
[quoted text clipped - 9 lines]
> TIA
> Brian

Reply to this Message

Brian - 13 Feb 2004 08:00 GMT

> 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

Reply to this Message

Jon Peltier - 13 Feb 2004 21:34 GMT

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/
_______

>>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.
>
[quoted text clipped - 10 lines]
>
> Brian

Reply to this Message