![]() |
MS-DEFCON 2:
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it.
|
-
Excel Charts only partly print
Home › Forums › AskWoody support › Microsoft Office by version › Excel Charts only partly print
- This topic has 6 replies, 3 voices, and was last updated 10 months, 2 weeks ago.
Viewing 5 reply threads-
AuthorPosts
-
-
February 23, 2020 at 5:17 pm #2170227
Foothills Dave
AskWoody PlusOn my new computer, purchased in the summer of 2019, when I go to print a chart in Excel the print preview shows the whole chart to be printed on 1 page, but when printed on either of my printers or to a pdf all that is printed is the top left hand corner of the chart, which fills the whole page.
On a spread sheet page there is the option Fit to 1 page by width and tall under page layout then scale to fit but that option is not there for chart sheets.
This very frustrating, any suggestions would be appreciated.
-
February 24, 2020 at 1:30 am #2170342
Kirsty
Manager@foothills-dave, you don’t seem to say which Excel version you are running, or your OS.
Are you trying to print only your graph, or the worksheet page with the graph?If you are printing the worksheet page: When you do a print preview, then return to your spreadsheet, where do the page lines lie? is your graph within the designated page area?
Even when mine isn’t, by clicking Fit Sheet on One Page, it all prints. (Scaling options are available for printing the worksheet, not the graph itself.) -
February 25, 2020 at 11:34 am #2171098
Foothills Dave
AskWoody PlusI am using Office Home & Basic 2019 on Widows 10 version 2003 64 bit. My old computer where I did not have the problem was Windows 7, with Office 2013 I think.
Each graph is on its own worksheet by itself. Print Preview shows the whole graph on 1 page, ready to go but when printed it only prints the top left corner of the graph. On the spread sheet pages there is the option Fit to 1 page by width and tall under page layout then scale to fit but that option is not there for chart sheets, I assume because (based on the print preview) it is only one page.
My work around has been to bring up the print preview, then print screen, then paste into a photo editing program, then cropping it and saving it as a jpg or pdf.
-
February 26, 2020 at 1:57 am #2171404
Kirsty
ManagerSorry Dave, I don’t have access to Office2019.
I suggest you have a play with these two MS Office support pages’ hints, especially the page setup setting for Fit to Page:
Print a chart
Excel for … 2019-2013, 365 (also 2007/10 on same page)Fit to one page
Excel for … 2019-2013, 365, web1 user thanked author for this post.
-
-
February 26, 2020 at 8:46 am #2171487
Kathy Stevens
AskWoody LoungerA work around for the Excel printing problem is to block and copy the cells or chart you want to print and then past them into a Word document.
Not an ideal solution but it works in a pinch.
1 user thanked author for this post.
-
February 26, 2020 at 10:52 am #2171556
Kathy Stevens
AskWoody LoungerA couple of questions.
- Have you ever been able to print Excel sheets using your, “Office Home & Basic 2019 on Widows 10 version 2003 64 bit” PC?
- Are you having problems printing Word documents?
- Are you using Adobe Acrobat or other third party PDF software to to print or the PDF creator built into Microsoft products?
1 user thanked author for this post.
-
March 16, 2020 at 3:30 pm #2199916
Foothills Dave
AskWoody PlusKathy,
Sorry to be so slow to respond.
Everything worked on my old computer using the old version, documents print fine, just not the graphs, either jpg or pdf.
However: The work around copying to Word worked, which lead me to discover that coping to another worksheet also worked, the first time. Which sort of accidentally let me to a very easy work around. If before I print the chart, in the print settings, before printing I switch to portrait, then back to Landscape, the chart prints perfectly. But I do have to do it each time.
I have no idea why that works, but it does. Go figure.
Thank you Kathy and Kirsty for your help.
1 user thanked author for this post.
-
-
AuthorPosts
Viewing 5 reply threads -
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments. Click here for details and to sign up.
Search The Lounge
Recent Replies
anonymous on Standalone installer script for Windows 7 ESU, regardless the license
27 minutes agoRick Corbett on User Feed Synchronization – Disable/Delete Task?
55 minutes agoOscarCP on Is this the best science fiction show ever?
1 hour, 50 minutes agoanonymous on Websites that still require Flash after EOL
3 hours, 59 minutes agoSusan Bradley on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
3 hours, 59 minutes agoanonymous on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
4 hours, 1 minute agoTex265 on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
4 hours, 30 minutes agogeekdom on MS-DEFCON 2 – Get ready for January updates
5 hours, 29 minutes agobuckwheat on MS-DEFCON 2 – Get ready for January updates
5 hours, 58 minutes agoBob99 on Can’t add, or remove, any bluetooth device
6 hours, 59 minutes agoDonald Crossman on Can’t add, or remove, any bluetooth device
7 hours, 8 minutes agoBob99 on Computer running slowly when using Wi-Fi since last Windows update
7 hours, 18 minutes agoBundaburra on Computer running slowly when using Wi-Fi since last Windows update
7 hours, 52 minutes agoBob99 on Can’t add, or remove, any bluetooth device
8 hours, 2 minutes agoanonymous on So I opened up an HP and where’s the hard drive?
8 hours, 32 minutes agoanonymous on Orange screen, white stripes, not using Bitlocker
8 hours, 32 minutes agoOscarCP on What Linux is and why it has persisted
8 hours, 39 minutes agoPKCano on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
8 hours, 40 minutes agolikescats on Files don’t copy from Win7 HDD to Win10 computer
8 hours, 47 minutes agoOscarCP on Do we need Java?
8 hours, 53 minutes agoTex265 on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
9 hours, 8 minutes agoOscarCP on Apple News Wrap Up: January 23, 2020
9 hours, 12 minutes agoWCHS on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
10 hours, 3 minutes agomn-- on So I opened up an HP and where’s the hard drive?
10 hours, 6 minutes agoPKCano on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
10 hours, 7 minutes agoTex265 on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
10 hours, 11 minutes agoOscarCP on Google threatens to remove search engine from Australia
10 hours, 14 minutes agoSteveTree on WinSlap 1.4 (Windows 10 Privacy tool) Portable
10 hours, 22 minutes agoMHCLV941 on Adobe Flash Not working for School test
10 hours, 27 minutes agoTex265 on Comments on AKB 2000016: Guide for Windows Update Settings for Windows 10
10 hours, 31 minutes ago
Recent Topics
-
Sorting alphanumeric text
3 hours, 55 minutes ago
-
Potential for iPhone 12 and MagSafe to Interfere With Medical Devices
11 hours, 54 minutes ago
-
Computer running slowly when using Wi-Fi since last Windows update
7 hours, 18 minutes ago
-
Websites that still require Flash after EOL
3 hours, 59 minutes ago
-
WinSlap 1.4 (Windows 10 Privacy tool) Portable
10 hours, 22 minutes ago
-
Using USB flash drive for both windows and on a Chromebook
16 hours, 35 minutes ago
-
Chrome browser stopped playing video
11 hours, 31 minutes ago
-
The Classic Browser v6.3
20 hours, 52 minutes ago
-
Apple News Wrap Up: January 23, 2020
9 hours, 13 minutes ago
-
Tasks for the Weekend – January 23, 2021
19 hours, 50 minutes ago
-
Need inexpensive domain
23 hours, 7 minutes ago
-
Outlook 2019 send and receive
22 hours, 52 minutes ago
-
Can’t add, or remove, any bluetooth device
6 hours, 59 minutes ago
-
Customize the mouse w10 2004–19041.746
1 day, 10 hours ago
-
Can’t install any programs since Win 2004 update
13 hours, 23 minutes ago
-
SFC errors not repairable, upgrade to 2004?
1 day, 7 hours ago
-
Slow file copy
1 day, 11 hours ago
-
Do we need Java?
8 hours, 53 minutes ago
-
Windows 10 version changes
1 day, 10 hours ago
-
Lost Post
1 day, 15 hours ago
-
Hasta la vista, TeamViewer Free
1 day, 7 hours ago
-
Files don’t copy from Win7 HDD to Win10 computer
8 hours, 48 minutes ago
-
Does the HP Spectre Notebook (2016 model) have a removable wireless LAN Card?
2 days, 1 hour ago
-
Windows 10 2004 and Intel Ethernet Problem Solving
1 day, 12 hours ago
-
KB4023057 while on Win10-2004
1 day, 13 hours ago
-
MS Shared Experience warning
2 days, 7 hours ago
-
Google threatens to remove search engine from Australia
10 hours, 14 minutes ago
-
macOS Catalina running on iPad Pro 2020
1 day ago
-
How to check if someone else accessed your Google account
2 days, 22 hours ago
-
This should be the best patching experience
23 hours ago
Search for Topics
Recent blog posts
- Tasks for the Weekend – January 23, 2021
- Slow file copy
- This should be the best patching experience
- So I opened up an HP and where’s the hard drive?
- What Linux is and why it has persisted
- Find the cable modem that’s just right for your ISP
- Four GB of RAM vanishes … but then reappears
- Wow! Even more Office updates!
Key Links
Copyright © 2004 – 2021 AskWoody Tech LLC. All rights reserved.