overlaying charts

  • Thread starter Thread starter Gary M
  • Start date Start date
G

Gary M

Hello

Does anyone know how to "overlay" charts, either in its
own worksheet or indepent of a worksheet?

I would like to display a "radar" chart inside a "donut"
chart and/or even create two "donut" charts and have the
circles outside of each other (obviously, one large than
the other one.)

I can show two charts together, but when I move one,
it ""hides behind the other chart. I have tried the "move
backward" and forward commands. No luck

It's almost like the background of the charts needs to be
transparent, so that only the chart cirle (with data) can
be seen.

Thanks in advance.
 
I did this similar thing for one of my clients and it's very easy to do.
Select the chart that will go 'on top' of the other chart and set its Format
Chart Area and Format Plot Area to None (mine were defaulted to Automatic).
Move this chart on top of the other chart then deselect the chart (either
click in another cell or hit the Esc key).
 
Hi Gary,

It is possible to create a donut with more than 1 ring.

Here some dummy data.
B1:=X C1:=Y
A2:=One B2:=1 C2:=3
A3:=Two B3:=2 C3:=2
A4:=Three B4:=3 C4:=1

To create a dual ring donut highlight the range A1:C4 and use the chart
wizard to create a donut.

If you need a gap between the 2 rings then add a dummy set of data.
Move col C data over to col D. Make the donut with 3 rings and the
format the middle ring, setting the border and fill pattern to None.

You can even change the chart type of one of the rings to be radar.
Simply select the series and right-click. One the popup menu choose
Chart Type and select Radar.

Cheers
Andy
 
Back
Top