Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How Do I Nail Down Chart Width for Printing
I must make line charts, bar charts, and pie charts a uniform width (either
6.75 inches or 3.45 inches) from spreadsheet files provided by different authors (but all using Excel 2007). I use page set up narrow margins, I make the base font for the entire sheet Arial 8, I draw a line 6.75 inches wide and generate the chart beneath this line. One sheet will print the chart and the line 6.75 inches spot on; another sheet (different file, same layout specs) will print the chart and the line 7.0 inches. Same workstation, same output device. I have checked properties so that the chart does not move or resize; no help. What am I missing? Mike |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How Do I Nail Down Chart Width for Printing
Hi Mike,
If you click on the chart, then click on the Format tab, then change the size in inches in the Size group, you should be able to set a specific chart width and height. ~Vrin "Mike" wrote: I must make line charts, bar charts, and pie charts a uniform width (either 6.75 inches or 3.45 inches) from spreadsheet files provided by different authors (but all using Excel 2007). I use page set up narrow margins, I make the base font for the entire sheet Arial 8, I draw a line 6.75 inches wide and generate the chart beneath this line. One sheet will print the chart and the line 6.75 inches spot on; another sheet (different file, same layout specs) will print the chart and the line 7.0 inches. Same workstation, same output device. I have checked properties so that the chart does not move or resize; no help. What am I missing? Mike |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How Do I Nail Down Chart Width for Printing
Hello, Vrin
Thank you for the reply. I have found through trial and error that adjustments that nail down a specific width must be made in the page layout view. The properties of the objects must be set to Go not move or size with cells, after which one can adjust the size of the columns to prevent spill onto an adjacent "page." I was surprised and miffed that a line drawn with a specific width would not hold that width when printed. What was even more puzzling was that in some cases the line would be a bit shorter, in others a bit longer. That result was unacceptable for our customer. It appears we can manage overall widths of tables as well as charts in the page layout view, ruler on. Mike "Vrin" wrote: Hi Mike, If you click on the chart, then click on the Format tab, then change the size in inches in the Size group, you should be able to set a specific chart width and height. ~Vrin "Mike" wrote: I must make line charts, bar charts, and pie charts a uniform width (either 6.75 inches or 3.45 inches) from spreadsheet files provided by different authors (but all using Excel 2007). I use page set up narrow margins, I make the base font for the entire sheet Arial 8, I draw a line 6.75 inches wide and generate the chart beneath this line. One sheet will print the chart and the line 6.75 inches spot on; another sheet (different file, same layout specs) will print the chart and the line 7.0 inches. Same workstation, same output device. I have checked properties so that the chart does not move or resize; no help. What am I missing? Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I would like to be nail salon assistant | Excel Discussion (Misc queries) | |||
Chart Bar Width | Excel Discussion (Misc queries) | |||
Printing cell's content larger than cell width | New Users to Excel | |||
Cant Seem to Nail this Lookup | Excel Worksheet Functions | |||
how can i find total width of the columns in a printing area ? | Excel Discussion (Misc queries) |