Excel 2010 Chart Not Printing To Size
I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the sheet, the chart re-sizes and centers in the middle of the page as if it does not matter how I format it. How do I get my print preview to look like how I have it in the edit mode.
microsoft-excel microsoft-excel-2010 printing charts
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
|
show 8 more comments
I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the sheet, the chart re-sizes and centers in the middle of the page as if it does not matter how I format it. How do I get my print preview to look like how I have it in the edit mode.
microsoft-excel microsoft-excel-2010 printing charts
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
1
There are several things that could be going on. If you click on the chart so it is selected at the time you print, it will print the chart. Make sure the chart is not selected when you print. Also, display the page break view and see what that shows. If the whole spreadsheet is larger than what will fit on a page, you could be getting the page that contains the chart, which could occupy a different location within that print page than what appears on the screen for the whole sheet.
– fixer1234
Nov 6 '14 at 19:29
1
What have you researched or attempted to resolve this? Edit your question to include more details. As it is, your question is missing a lot of information we would need to be able to answer it. Printer settings are a major factor, are specific to each printer and act differently than the view settings. As fixer1234 states, it depends on how you are trying to print the chart. The page break preview will help you see if it is being automatically scaled to fit the page.
– CharlieRB
Nov 6 '14 at 19:35
This is an automatic excel creation and print that is launched by another program. The program loads a template, fills it with info, then prints. Every view besides the print preview looks correct. The print preview shows all the data underneath, but the chart instead of being displayed as it is sized, re-sizes to maximum and forces it into the center of the page. It is as if it is printing the chart and the data as two separate items overlapped on the same page. This issue is only on my computer, other computers are not having this problem.
– Khamey
Nov 6 '14 at 19:59
@fixer1234 I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:12
@CharlieRB I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:13
|
show 8 more comments
I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the sheet, the chart re-sizes and centers in the middle of the page as if it does not matter how I format it. How do I get my print preview to look like how I have it in the edit mode.
microsoft-excel microsoft-excel-2010 printing charts
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
I have an excel spreadsheet that I am trying to print with a chart located in it. The chart is properly sized in the spreadsheet and looks fine when viewing it in the editor. When I go to print the sheet, the chart re-sizes and centers in the middle of the page as if it does not matter how I format it. How do I get my print preview to look like how I have it in the edit mode.
microsoft-excel microsoft-excel-2010 printing charts
microsoft-excel microsoft-excel-2010 printing charts
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
edited Nov 10 '14 at 16:18
fixer1234
18.4k144781
18.4k144781
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
asked Nov 6 '14 at 18:57
KhameyKhamey
10111
10111
1
There are several things that could be going on. If you click on the chart so it is selected at the time you print, it will print the chart. Make sure the chart is not selected when you print. Also, display the page break view and see what that shows. If the whole spreadsheet is larger than what will fit on a page, you could be getting the page that contains the chart, which could occupy a different location within that print page than what appears on the screen for the whole sheet.
– fixer1234
Nov 6 '14 at 19:29
1
What have you researched or attempted to resolve this? Edit your question to include more details. As it is, your question is missing a lot of information we would need to be able to answer it. Printer settings are a major factor, are specific to each printer and act differently than the view settings. As fixer1234 states, it depends on how you are trying to print the chart. The page break preview will help you see if it is being automatically scaled to fit the page.
– CharlieRB
Nov 6 '14 at 19:35
This is an automatic excel creation and print that is launched by another program. The program loads a template, fills it with info, then prints. Every view besides the print preview looks correct. The print preview shows all the data underneath, but the chart instead of being displayed as it is sized, re-sizes to maximum and forces it into the center of the page. It is as if it is printing the chart and the data as two separate items overlapped on the same page. This issue is only on my computer, other computers are not having this problem.
– Khamey
Nov 6 '14 at 19:59
@fixer1234 I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:12
@CharlieRB I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:13
|
show 8 more comments
1
There are several things that could be going on. If you click on the chart so it is selected at the time you print, it will print the chart. Make sure the chart is not selected when you print. Also, display the page break view and see what that shows. If the whole spreadsheet is larger than what will fit on a page, you could be getting the page that contains the chart, which could occupy a different location within that print page than what appears on the screen for the whole sheet.
– fixer1234
Nov 6 '14 at 19:29
1
What have you researched or attempted to resolve this? Edit your question to include more details. As it is, your question is missing a lot of information we would need to be able to answer it. Printer settings are a major factor, are specific to each printer and act differently than the view settings. As fixer1234 states, it depends on how you are trying to print the chart. The page break preview will help you see if it is being automatically scaled to fit the page.
– CharlieRB
Nov 6 '14 at 19:35
This is an automatic excel creation and print that is launched by another program. The program loads a template, fills it with info, then prints. Every view besides the print preview looks correct. The print preview shows all the data underneath, but the chart instead of being displayed as it is sized, re-sizes to maximum and forces it into the center of the page. It is as if it is printing the chart and the data as two separate items overlapped on the same page. This issue is only on my computer, other computers are not having this problem.
– Khamey
Nov 6 '14 at 19:59
@fixer1234 I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:12
@CharlieRB I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:13
1
1
There are several things that could be going on. If you click on the chart so it is selected at the time you print, it will print the chart. Make sure the chart is not selected when you print. Also, display the page break view and see what that shows. If the whole spreadsheet is larger than what will fit on a page, you could be getting the page that contains the chart, which could occupy a different location within that print page than what appears on the screen for the whole sheet.
– fixer1234
Nov 6 '14 at 19:29
There are several things that could be going on. If you click on the chart so it is selected at the time you print, it will print the chart. Make sure the chart is not selected when you print. Also, display the page break view and see what that shows. If the whole spreadsheet is larger than what will fit on a page, you could be getting the page that contains the chart, which could occupy a different location within that print page than what appears on the screen for the whole sheet.
– fixer1234
Nov 6 '14 at 19:29
1
1
What have you researched or attempted to resolve this? Edit your question to include more details. As it is, your question is missing a lot of information we would need to be able to answer it. Printer settings are a major factor, are specific to each printer and act differently than the view settings. As fixer1234 states, it depends on how you are trying to print the chart. The page break preview will help you see if it is being automatically scaled to fit the page.
– CharlieRB
Nov 6 '14 at 19:35
What have you researched or attempted to resolve this? Edit your question to include more details. As it is, your question is missing a lot of information we would need to be able to answer it. Printer settings are a major factor, are specific to each printer and act differently than the view settings. As fixer1234 states, it depends on how you are trying to print the chart. The page break preview will help you see if it is being automatically scaled to fit the page.
– CharlieRB
Nov 6 '14 at 19:35
This is an automatic excel creation and print that is launched by another program. The program loads a template, fills it with info, then prints. Every view besides the print preview looks correct. The print preview shows all the data underneath, but the chart instead of being displayed as it is sized, re-sizes to maximum and forces it into the center of the page. It is as if it is printing the chart and the data as two separate items overlapped on the same page. This issue is only on my computer, other computers are not having this problem.
– Khamey
Nov 6 '14 at 19:59
This is an automatic excel creation and print that is launched by another program. The program loads a template, fills it with info, then prints. Every view besides the print preview looks correct. The print preview shows all the data underneath, but the chart instead of being displayed as it is sized, re-sizes to maximum and forces it into the center of the page. It is as if it is printing the chart and the data as two separate items overlapped on the same page. This issue is only on my computer, other computers are not having this problem.
– Khamey
Nov 6 '14 at 19:59
@fixer1234 I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:12
@fixer1234 I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:12
@CharlieRB I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:13
@CharlieRB I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:13
|
show 8 more comments
2 Answers
2
active
oldest
votes
I've come across the same problem. Try to print 4 charts from Excel to one page and Excel looks good, even in page layout mode. Print preview, however, changes their size and page positions.
The problem seems to stem from seemingly simple chart properties. Go to 'Format Chart Area' and examine Properties. My problem went away when I checked the 'Move but don't size with cells' option. In Size, Scale Height and Width are both set to 100%. Now, all 4 charts preview and print on one page (Landscape), correctly positioned and sized. I assume if the same charts are populated by macro or from 'feeding' sheets, they will print correctly if these settings are correct.
answered Jul 17 '16 at 17:11
NodNod
111
add a comment |
I was having this same problem in Office 365 (Excel version 1808).
I fixed it by going to Format Chart Area > Properties then changing the radio buttons for the move/size setting. It seems that changing this setting at all fixes the problem. In my case, I changed it to "Move and size with cells" then immediately right back to the setting it was on previously ("Move but don't size with cells").
answered Sep 21 '18 at 19:04
xx99xx99
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f836839%2fexcel-2010-chart-not-printing-to-size%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I've come across the same problem. Try to print 4 charts from Excel to one page and Excel looks good, even in page layout mode. Print preview, however, changes their size and page positions.
The problem seems to stem from seemingly simple chart properties. Go to 'Format Chart Area' and examine Properties. My problem went away when I checked the 'Move but don't size with cells' option. In Size, Scale Height and Width are both set to 100%. Now, all 4 charts preview and print on one page (Landscape), correctly positioned and sized. I assume if the same charts are populated by macro or from 'feeding' sheets, they will print correctly if these settings are correct.
answered Jul 17 '16 at 17:11
NodNod
111
add a comment |
I've come across the same problem. Try to print 4 charts from Excel to one page and Excel looks good, even in page layout mode. Print preview, however, changes their size and page positions.
The problem seems to stem from seemingly simple chart properties. Go to 'Format Chart Area' and examine Properties. My problem went away when I checked the 'Move but don't size with cells' option. In Size, Scale Height and Width are both set to 100%. Now, all 4 charts preview and print on one page (Landscape), correctly positioned and sized. I assume if the same charts are populated by macro or from 'feeding' sheets, they will print correctly if these settings are correct.
answered Jul 17 '16 at 17:11
NodNod
111
add a comment |
I've come across the same problem. Try to print 4 charts from Excel to one page and Excel looks good, even in page layout mode. Print preview, however, changes their size and page positions.
The problem seems to stem from seemingly simple chart properties. Go to 'Format Chart Area' and examine Properties. My problem went away when I checked the 'Move but don't size with cells' option. In Size, Scale Height and Width are both set to 100%. Now, all 4 charts preview and print on one page (Landscape), correctly positioned and sized. I assume if the same charts are populated by macro or from 'feeding' sheets, they will print correctly if these settings are correct.
answered Jul 17 '16 at 17:11
NodNod
111
I've come across the same problem. Try to print 4 charts from Excel to one page and Excel looks good, even in page layout mode. Print preview, however, changes their size and page positions.
The problem seems to stem from seemingly simple chart properties. Go to 'Format Chart Area' and examine Properties. My problem went away when I checked the 'Move but don't size with cells' option. In Size, Scale Height and Width are both set to 100%. Now, all 4 charts preview and print on one page (Landscape), correctly positioned and sized. I assume if the same charts are populated by macro or from 'feeding' sheets, they will print correctly if these settings are correct.
answered Jul 17 '16 at 17:11
NodNod
111
answered Jul 17 '16 at 17:11
NodNod
111
answered Jul 17 '16 at 17:11
NodNod
111
answered Jul 17 '16 at 17:11
NodNod
111
111
add a comment |
add a comment |
I was having this same problem in Office 365 (Excel version 1808).
I fixed it by going to Format Chart Area > Properties then changing the radio buttons for the move/size setting. It seems that changing this setting at all fixes the problem. In my case, I changed it to "Move and size with cells" then immediately right back to the setting it was on previously ("Move but don't size with cells").
answered Sep 21 '18 at 19:04
xx99xx99
1
add a comment |
I was having this same problem in Office 365 (Excel version 1808).
I fixed it by going to Format Chart Area > Properties then changing the radio buttons for the move/size setting. It seems that changing this setting at all fixes the problem. In my case, I changed it to "Move and size with cells" then immediately right back to the setting it was on previously ("Move but don't size with cells").
answered Sep 21 '18 at 19:04
xx99xx99
1
add a comment |
I was having this same problem in Office 365 (Excel version 1808).
I fixed it by going to Format Chart Area > Properties then changing the radio buttons for the move/size setting. It seems that changing this setting at all fixes the problem. In my case, I changed it to "Move and size with cells" then immediately right back to the setting it was on previously ("Move but don't size with cells").
answered Sep 21 '18 at 19:04
xx99xx99
1
I was having this same problem in Office 365 (Excel version 1808).
I fixed it by going to Format Chart Area > Properties then changing the radio buttons for the move/size setting. It seems that changing this setting at all fixes the problem. In my case, I changed it to "Move and size with cells" then immediately right back to the setting it was on previously ("Move but don't size with cells").
answered Sep 21 '18 at 19:04
xx99xx99
1
answered Sep 21 '18 at 19:04
xx99xx99
1
answered Sep 21 '18 at 19:04
xx99xx99
1
answered Sep 21 '18 at 19:04
xx99xx99
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f836839%2fexcel-2010-chart-not-printing-to-size%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
There are several things that could be going on. If you click on the chart so it is selected at the time you print, it will print the chart. Make sure the chart is not selected when you print. Also, display the page break view and see what that shows. If the whole spreadsheet is larger than what will fit on a page, you could be getting the page that contains the chart, which could occupy a different location within that print page than what appears on the screen for the whole sheet.
– fixer1234
Nov 6 '14 at 19:29
1
What have you researched or attempted to resolve this? Edit your question to include more details. As it is, your question is missing a lot of information we would need to be able to answer it. Printer settings are a major factor, are specific to each printer and act differently than the view settings. As fixer1234 states, it depends on how you are trying to print the chart. The page break preview will help you see if it is being automatically scaled to fit the page.
– CharlieRB
Nov 6 '14 at 19:35
This is an automatic excel creation and print that is launched by another program. The program loads a template, fills it with info, then prints. Every view besides the print preview looks correct. The print preview shows all the data underneath, but the chart instead of being displayed as it is sized, re-sizes to maximum and forces it into the center of the page. It is as if it is printing the chart and the data as two separate items overlapped on the same page. This issue is only on my computer, other computers are not having this problem.
– Khamey
Nov 6 '14 at 19:59
@fixer1234 I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:12
@CharlieRB I have posted the question with an image on stackoverflow as I do not have enough rep here to post images. stackoverflow.com/questions/26788546/…
– Khamey
Nov 6 '14 at 20:13