double graph overlay

[Pedro]

Hello,

I'm trying to overlay 2 different chart types (xy scatter & bubble
over each other, both charts using the same data range.
how can I do this, or make 1 of the graphs transparent

 

[Jon Peltier]

Pedro -

Yep, that's one way to do it, and I have a rudimentary macro on this
page that can help:

http://peltiertech.com/Excel/Charts/AlignCharts.html

Another way is to put your bubble data into the same XY chart, then use
custom markers instead of bubbles. You can draw circles of the
appropriate size and use them as markers:

http://peltiertech.com/Excel/ChartsHowTo/CustomSeriesFormatting.html

To automate this, follow the procedure on Microsoft's site. It's not a
true bubble chart they're making, it's an XY chart with different oval
sizes:

http://support.microsoft.com/default.aspx?scid=kb;[LN];139662

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Rippbird]

How do you make the one chart transparent? HELP is no help. When I choose
"fill effects" from either the plot format or chart format menus, the
transparency menus under the Gradient tab are greyed out.

HELP!

Pedro -

Yep, that's one way to do it, and I have a rudimentary macro on this
page that can help:

http://peltiertech.com/Excel/Charts/AlignCharts.html

Another way is to put your bubble data into the same XY chart, then use
custom markers instead of bubbles. You can draw circles of the
appropriate size and use them as markers:

http://peltiertech.com/Excel/ChartsHowTo/CustomSeriesFormatting.html

To automate this, follow the procedure on Microsoft's site. It's not a
true bubble chart they're making, it's an XY chart with different oval
sizes:

http://support.microsoft.com/default.aspx?scid=kb;[LN];139662

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Rippbird]

How do you make the one chart transparent? HELP is no help. When I choose
"fill effects" from either the plot format or chart format menus, the
transparency menus under the Gradient tab are greyed out.

HELP!

Pedro -

Yep, that's one way to do it, and I have a rudimentary macro on this
page that can help:

http://peltiertech.com/Excel/Charts/AlignCharts.html

Another way is to put your bubble data into the same XY chart, then use
custom markers instead of bubbles. You can draw circles of the
appropriate size and use them as markers:

http://peltiertech.com/Excel/ChartsHowTo/CustomSeriesFormatting.html

To automate this, follow the procedure on Microsoft's site. It's not a
true bubble chart they're making, it's an XY chart with different oval
sizes:

http://support.microsoft.com/default.aspx?scid=kb;[LN];139662

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Bernard Liengme]

Format Plot Area: fill None
Format Chart Area: fill None
But wait, the chart still look opaque white!
Now click in an empty cell to deselect the chart. The chart should be
see-thru now.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

How do you make the one chart transparent? HELP is no help. When I
choose
"fill effects" from either the plot format or chart format menus, the
transparency menus under the Gradient tab are greyed out.

HELP!

Pedro -

Yep, that's one way to do it, and I have a rudimentary macro on this
page that can help:

http://peltiertech.com/Excel/Charts/AlignCharts.html

Another way is to put your bubble data into the same XY chart, then use
custom markers instead of bubbles. You can draw circles of the
appropriate size and use them as markers:

http://peltiertech.com/Excel/ChartsHowTo/CustomSeriesFormatting.html

To automate this, follow the procedure on Microsoft's site. It's not a
true bubble chart they're making, it's an XY chart with different oval
sizes:

http://support.microsoft.com/default.aspx?scid=kb;[LN];139662

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Hello,

I'm trying to overlay 2 different chart types (xy scatter & bubble)
over each other, both charts using the same data range.
how can I do this, or make 1 of the graphs transparent?