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.
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.