Grouping overlaying charts

K

Klemen25

Hello

Excel 2003.
I created a chart, copied it and formatted the copy to be transparent
and changed some source data. I now want to overlay it over the
original chart (in this way I accomplish that there are 2 legends in
one chart).

If I don't overlay them totally, I can select both charts and group
them, and than I can copy the grouped picture into Power Point.

But if I overlay them as it should be (so that they completely cover
each other- so it seems as there is only one chart) I can't select
both charts to group them.

Is there any way, and if not what about some macro to tell excel to
group object1 (chart1) and object2 (chart2), regardless where they are
in a worksheet?

Thank you for your help.
 
K

Klemen25

I think I figured it out. You can group the charts when you can still
select both. Than you ungroup and correctly overlay them and than
select the option regroup.
Sorry for waiting your time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top