Excel construct single chart from 2 charts

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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 said:
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.
Click to expand...

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
 
Back
Top