Please help! I have a worksheet with an embedded chart in it. The
chart background is coloured blue and the pie chart within it is multi
coloured. When I click on print preview I can see the worksheet with a
blue box where the chart is but the multi-coloured pie chart has
disappeared. So it is like the chart background is there but not the
chart itself.
Can anyone explain this?
Kind regards & TIA
Stuart
Select the chart, from Format menu, choose Selected Chart Area. On
Properties tab, check the Print Object checkbox.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
> Please help! I have a worksheet with an embedded chart in it. The
> chart background is coloured blue and the pie chart within it is multi
[quoted text clipped - 9 lines]
> Stuart
> :-)
stuart_bisset@yahoo.com - 17 Feb 2006 13:47 GMT
Thanks Jon, I wasn't aware of that setting previously BUT it was
ticked. I have unticked it and reticked it to see what happens (the
blue background disappeared and reappeared) but still no pie chart in
the middle.
Stuart
stuart_bisset@yahoo.com - 17 Feb 2006 16:38 GMT
Sorted it out - sometimes you can't see the wood for the trees. Took
me a while to realise it but previous spreadsheet owner had set hugely
wide columns and massive text font but viewed at a zoom of 12% so it
looked like a fairly ordinary sized worksheet with an ordinary sized
graph. When clicking print preview the graph mustn't be able to resize
itself in that scenario so the reason I was only seeing background was
simply because the print preview of the graph probably only represented
a small corner of the, say, top left or bottom right of the background.
The rest of the graph was "off screen" if you like. Strange one, but
i thought i'd post the answer anyway, in case anyone else ever
encounters this same prob.
Jon Peltier - 19 Feb 2006 19:38 GMT
We'll add it to the list of Things to Watch Out For.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
> Sorted it out - sometimes you can't see the wood for the trees. Took
> me a while to realise it but previous spreadsheet owner had set hugely
[quoted text clipped - 7 lines]
> i thought i'd post the answer anyway, in case anyone else ever
> encounters this same prob.