One chart embedded into another chart.

[Victor]

I am trying to stick a line chart to the bottom of a
doughnut chart. I need them to both act as the one chart
as
i have quite a few of these combined charts to setup and
format.

 

[Jon Peltier]

Hi Victor -

I'm not sure what you mean, to "stick" the charts together. On my web
site, I have a dashboard style chart that combines a donut chart and a
scatter chart. The axis scales of the scatter chart are defined in such
a way that the axes cross at the center of the donut. Perhaps it will
show you how to align your charts.

http://www.geocities.com/jonpeltier/Excel/Charts/Speedometer.html

- Jon

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting and a copy
was sent to the cited author.]

Put the doughnut chart on a (separate) chart sheet and the other should
be an embedded chart on that chart sheet.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office