A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing Excel 2007 Chart



 
 
Thread Tools Display Modes
  #1  
Old October 8th, 2009, 04:14 PM posted to microsoft.public.excel.misc
SeanF74
external usenet poster
 
Posts: 21
Default Printing Excel 2007 Chart

Hello-

I have a bar chart that I want to print from excel 2007, but it does not
print correctly. Let me explain:

I created a bar chart that has a x axis with range from -100% to 100%.
There are 31 items on the y axis ranging from -30% to 1400% (as would be
expected, the ones above 100% are cut off as wanted). Moving downward on the
y axis, the values in the bar chart are acending. The final 18 at the
bottom have values greater than 100%. When it is on the screen, it looks as
would be expected.

However, when I print, the 26 at the top print out fine, but number 27
prints out with a negative value and the last 4 have no bar whatsoever. When
I paste a link or a Microsoft Office Graphic Object of this same chart into
powerpoint, it appears on the computer screen fine but also prints out the
same way it prints from Excel (when I paste as a picture, it prints out
fine). It printed out correctly when I exported it to PDF format and then
printed, but I want to be able to print directly from excel without having to
deal with exporting or pasting it into another document as a picture in order
to print. I also printed it on the 3 different HP laser jet printers which I
have mapped to this computer with the same result. Does anyone know what is
going on with this?

thank you !
  #2  
Old October 8th, 2009, 04:35 PM posted to microsoft.public.excel.misc
BSc Chem Eng Rick
external usenet poster
 
Posts: 98
Default Printing Excel 2007 Chart

Hi Sean

Try making all values greater than 100%, equal to 100% (manually if need be)
and see if you get the same issue. If not just include a condition that
anything greather than 100% is set to 100%, the formula would look something
like this

=IF(YourFormulaOutput 1, 1, YourFormulaOutput)

If this helps please click "Yes"


"SeanF74" wrote:

Hello-

I have a bar chart that I want to print from excel 2007, but it does not
print correctly. Let me explain:

I created a bar chart that has a x axis with range from -100% to 100%.
There are 31 items on the y axis ranging from -30% to 1400% (as would be
expected, the ones above 100% are cut off as wanted). Moving downward on the
y axis, the values in the bar chart are acending. The final 18 at the
bottom have values greater than 100%. When it is on the screen, it looks as
would be expected.

However, when I print, the 26 at the top print out fine, but number 27
prints out with a negative value and the last 4 have no bar whatsoever. When
I paste a link or a Microsoft Office Graphic Object of this same chart into
powerpoint, it appears on the computer screen fine but also prints out the
same way it prints from Excel (when I paste as a picture, it prints out
fine). It printed out correctly when I exported it to PDF format and then
printed, but I want to be able to print directly from excel without having to
deal with exporting or pasting it into another document as a picture in order
to print. I also printed it on the 3 different HP laser jet printers which I
have mapped to this computer with the same result. Does anyone know what is
going on with this?

thank you !

  #3  
Old October 8th, 2009, 04:44 PM posted to microsoft.public.excel.misc
SeanF74
external usenet poster
 
Posts: 21
Default Printing Excel 2007 Chart

Thanks, it worked.

"BSc Chem Eng Rick" wrote:

Hi Sean

Try making all values greater than 100%, equal to 100% (manually if need be)
and see if you get the same issue. If not just include a condition that
anything greather than 100% is set to 100%, the formula would look something
like this

=IF(YourFormulaOutput 1, 1, YourFormulaOutput)

If this helps please click "Yes"


"SeanF74" wrote:

Hello-

I have a bar chart that I want to print from excel 2007, but it does not
print correctly. Let me explain:

I created a bar chart that has a x axis with range from -100% to 100%.
There are 31 items on the y axis ranging from -30% to 1400% (as would be
expected, the ones above 100% are cut off as wanted). Moving downward on the
y axis, the values in the bar chart are acending. The final 18 at the
bottom have values greater than 100%. When it is on the screen, it looks as
would be expected.

However, when I print, the 26 at the top print out fine, but number 27
prints out with a negative value and the last 4 have no bar whatsoever. When
I paste a link or a Microsoft Office Graphic Object of this same chart into
powerpoint, it appears on the computer screen fine but also prints out the
same way it prints from Excel (when I paste as a picture, it prints out
fine). It printed out correctly when I exported it to PDF format and then
printed, but I want to be able to print directly from excel without having to
deal with exporting or pasting it into another document as a picture in order
to print. I also printed it on the 3 different HP laser jet printers which I
have mapped to this computer with the same result. Does anyone know what is
going on with this?

thank you !

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.