Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute Scale of Chart Printout
I am generating charts with excel and would like it, when printed to
be at a specific scale. For instance, I have a xy chart which has a circle plotted on a grid that I would like to print as 10 squares per inch (or possible 2 squares per centemeter) grid on the paper, and the circle to be precisely 3 inch diameter. Any assistance or direction would be appreciated. Thanks in advance, TomC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute Scale of Chart Printout
The best way is to experiment manually. The print menu has a scale option
and adjust the scale numbe to meet your requirements. the workshet is dimensioned in pixels and the only inch (cm) options ar on the print menu for the border. "tomcee" wrote: I am generating charts with excel and would like it, when printed to be at a specific scale. For instance, I have a xy chart which has a circle plotted on a grid that I would like to print as 10 squares per inch (or possible 2 squares per centemeter) grid on the paper, and the circle to be precisely 3 inch diameter. Any assistance or direction would be appreciated. Thanks in advance, TomC |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute Scale of Chart Printout
Thanks, But I'm looking for a more well-defined approach.
anybody? Thanks, TomC On Aug 23, 5:48*pm, Joel wrote: The best way is to experiment manually. *The print menu has a scale option and adjust the scale numbe to meet your requirements. *the workshet is dimensioned in pixels and the only inch (cm) options ar on the print menu for the border. "tomcee" wrote: I am generating charts with excel and would like it, when printed to be at a specific scale. For instance, I have a xy chart which has a circle plotted on a grid that I would like to print as 10 squares per inch (or possible 2 squares per centemeter) grid on the paper, and the circle to be precisely 3 inch diameter. Any assistance or direction would be appreciated. Thanks in advance, TomC- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute Scale of Chart Printout
the problem is the screen is inj pixels and the page size is in inches. The
mapping between the pixels and the inches is dependant on the print drive and the size of you monitor. One way to minimize the vairbles is to set the printer option to scale to fit paper size. Then in excel set the Print area. the you have to figure the number of pixels arre in the print areaa you defined on the worksheet. The run this macro to find the number of pixels in your print area Sub Macro1() ' ' Macro1 Macro ' Macro recorded 9/14/2009 by jwarburg ' ' StartRow = InputBox("Enter Start Row") EndRow = InputBox("Enter End Row") StartCol = InputBox("Enter Start Column") EndCol = InputBox("Enter End Column") PixelsRow = 0 For RowCount = StartRow To EndRow PixelsRow = PixelsRow + Rows(RowCount).RowHeight Next RowCount PixelsCol = 0 For ColCount = StartCol To EndCol PixelsCol = PixelsCol + Columns(ColCount).RowHeight Next ColCount MsgBox ("Your area is " & PixelsRow & " high by " & PixelsCol & " wide") End Sub The print scaling will scale proportionaly so the so you have to figure out wha the scaling ratios are. And then in the end you will havve to make minor adjustments for the border area the print dirve is using or change the size of the border. "tchrapkiewicz" wrote: Thanks, But I'm looking for a more well-defined approach. anybody? Thanks, TomC On Aug 23, 5:48 pm, Joel wrote: The best way is to experiment manually. The print menu has a scale option and adjust the scale numbe to meet your requirements. the workshet is dimensioned in pixels and the only inch (cm) options ar on the print menu for the border. "tomcee" wrote: I am generating charts with excel and would like it, when printed to be at a specific scale. For instance, I have a xy chart which has a circle plotted on a grid that I would like to print as 10 squares per inch (or possible 2 squares per centemeter) grid on the paper, and the circle to be precisely 3 inch diameter. Any assistance or direction would be appreciated. Thanks in advance, TomC- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute Scale of Chart Printout
On Sep 14, 5:36*am, Joel wrote:
the problem is the screen is inj pixels and the page size is in inches. *The mapping between the pixels and the inches is dependant on the print drive and the size of you monitor. *One way to minimize the vairbles is to set the printer option to scale to fit paper size. *Then in excel set the Print area. *the you have to figure the number of pixels arre in the print areaa you defined on the worksheet. * The run this macro to find the number of pixels in your print area Sub Macro1() ' ' Macro1 Macro ' Macro recorded 9/14/2009 by jwarburg ' ' StartRow = InputBox("Enter Start Row") EndRow = InputBox("Enter End Row") StartCol = InputBox("Enter Start Column") EndCol = InputBox("Enter End Column") PixelsRow = 0 For RowCount = StartRow To EndRow * *PixelsRow = PixelsRow + Rows(RowCount).RowHeight Next RowCount PixelsCol = 0 For ColCount = StartCol To EndCol * *PixelsCol = PixelsCol + Columns(ColCount).RowHeight Next ColCount MsgBox ("Your area is " & PixelsRow & " high by " & PixelsCol & " wide") End Sub The print scaling will scale proportionaly so the so you have to figure out wha the scaling ratios are. *And then in the end you will havve to make minor adjustments for the border area the print dirve is using or change the size of the border. "tchrapkiewicz" wrote: Thanks, But I'm looking for a more well-defined approach. anybody? Thanks, TomC On Aug 23, 5:48 pm, Joel wrote: The best way is to experiment manually. *The print menu has a scale option and adjust the scale numbe to meet your requirements. *the workshet is dimensioned in pixels and the only inch (cm) options ar on the print menu for the border. "tomcee" wrote: I am generating charts with excel and would like it, when printed to be at a specific scale. For instance, I have a xy chart which has a circle plotted on a grid that I would like to print as 10 squares per inch (or possible 2 squares per centemeter) grid on the paper, and the circle to be precisely 3 inch diameter. Any assistance or direction would be appreciated. Thanks in advance, TomC- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Joel: Thank you very much! This seems to be what I was looking for. I'll give it a try. Regards, TomC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart scale changes | Charts and Charting in Excel | |||
Dynamically Scale Gantt Chart Time Scale | Charts and Charting in Excel | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
vc++ automation: opening chart as chart window and setting scale | Excel Programming |