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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|