Printing Excel 2007 Chart

S

SeanF74

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 !
 
B

BSc Chem Eng Rick

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"
<><><><><><><><><><>
 
S

SeanF74

Thanks, it worked.

BSc Chem Eng Rick said:
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"
<><><><><><><><><><>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top