Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart printing issue in Excel 2007 | Charts and Charting in Excel | |||
Printing in 2007 excel | Excel Discussion (Misc queries) | |||
printing in excel 2007 | New Users to Excel | |||
Excel 2007 not printing | Excel Discussion (Misc queries) | |||
Printing Pivot Chart in 2007 | Excel Discussion (Misc queries) |