Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / February 2006

Tip: Looking for answers? Try searching our database.

Embedded Chart does not appear on print preview

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
stuart_bisset@yahoo.com - 16 Feb 2006 14:45 GMT
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
:-)
Jon Peltier - 17 Feb 2006 04:34 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.