Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different chart sizes between Excel 2007 and previous versions
I am plotting several charts in Excel on a single page report, controlling
the process with VB.NET; in the VB.NET application I define all the charts parameters (fonts, sizes, positions, etc.), and the page parameters (margins, headers, etc); when I run the application in PCs with Excel 2000 or 2003 the output page is printed as expected, but if I run it in a PC with Excel 2007, the charts are displayed bigger and my one-page report becomes a multiple page report with pieces of my charts dispalyed in several pages. It looks like the chart sizes in 2007 are measured differently than in previous versions. Has anybody had the same problem ? If so, is there a workaround ? Thanks. MD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different chart sizes between Excel 2007 and previous versions
If you have only tried it on one system that runs xl2007, you might want to
check the system set up. It is possible that the problem is in things like resolution, etc. However, if you have the problem on more than one system, then it could be a difference in the software properties. I have not worked with xl2007, but I would think that type of condition would have been accounted for during design. "MD" wrote: I am plotting several charts in Excel on a single page report, controlling the process with VB.NET; in the VB.NET application I define all the charts parameters (fonts, sizes, positions, etc.), and the page parameters (margins, headers, etc); when I run the application in PCs with Excel 2000 or 2003 the output page is printed as expected, but if I run it in a PC with Excel 2007, the charts are displayed bigger and my one-page report becomes a multiple page report with pieces of my charts dispalyed in several pages. It looks like the chart sizes in 2007 are measured differently than in previous versions. Has anybody had the same problem ? If so, is there a workaround ? Thanks. MD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different chart sizes between Excel 2007 and previous versions
There are lots of slight differences. The default font is different, so the
column width may be off. If you use points for chart size instead of basing it on the cell size, your chart may no longer align with cell boundaries. I haven't used Excel 2007 in enough client projects to have worried about details like this, so I can't help much further. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MD" wrote in message ... I am plotting several charts in Excel on a single page report, controlling the process with VB.NET; in the VB.NET application I define all the charts parameters (fonts, sizes, positions, etc.), and the page parameters (margins, headers, etc); when I run the application in PCs with Excel 2000 or 2003 the output page is printed as expected, but if I run it in a PC with Excel 2007, the charts are displayed bigger and my one-page report becomes a multiple page report with pieces of my charts dispalyed in several pages. It looks like the chart sizes in 2007 are measured differently than in previous versions. Has anybody had the same problem ? If so, is there a workaround ? Thanks. MD |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different chart sizes between Excel 2007 and previous versions
"Jon Peltier" wrote: There are lots of slight differences. The default font is different, so the column width may be off. If you use points for chart size instead of basing it on the cell size, your chart may no longer align with cell boundaries. I haven't used Excel 2007 in enough client projects to have worried about details like this, so I can't help much further. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MD" wrote in message ... I am plotting several charts in Excel on a single page report, controlling the process with VB.NET; in the VB.NET application I define all the charts parameters (fonts, sizes, positions, etc.), and the page parameters (margins, headers, etc); when I run the application in PCs with Excel 2000 or 2003 the output page is printed as expected, but if I run it in a PC with Excel 2007, the charts are displayed bigger and my one-page report becomes a multiple page report with pieces of my charts dispalyed in several pages. It looks like the chart sizes in 2007 are measured differently than in previous versions. Has anybody had the same problem ? If so, is there a workaround ? Thanks. MD Jon: How can I base my chart in cell size and not in points ? Also, I am aware about the differences in default fonts, that is why I am initializing everything to Arial 10pt, using the same cell width and so on, but still XL2007 prints differently. Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different chart sizes between Excel 2007 and previous versions
How can I base my chart in cell size and not in points ?
Suppose you want the chart to cover $C$5:$G$20. This code shows what you need. Sub ResizeChart() Dim chtob As ChartObject Dim rng As Range Set chtob = ActiveSheet.ChartObjects(1) Set rng = ActiveSheet.Range("C5:G20") chtob.Top = rng.Top chtob.Left = rng.Left chtob.Width = rng.Width chtob.Height = rng.Height End Sub If the printing of a file in 2007 still doesn't work right, about all I can do is wave my hands, scratch my chin, and suggest trying different printers or upgrading printer drivers. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MD" wrote in message ... "Jon Peltier" wrote: There are lots of slight differences. The default font is different, so the column width may be off. If you use points for chart size instead of basing it on the cell size, your chart may no longer align with cell boundaries. I haven't used Excel 2007 in enough client projects to have worried about details like this, so I can't help much further. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MD" wrote in message ... I am plotting several charts in Excel on a single page report, controlling the process with VB.NET; in the VB.NET application I define all the charts parameters (fonts, sizes, positions, etc.), and the page parameters (margins, headers, etc); when I run the application in PCs with Excel 2000 or 2003 the output page is printed as expected, but if I run it in a PC with Excel 2007, the charts are displayed bigger and my one-page report becomes a multiple page report with pieces of my charts dispalyed in several pages. It looks like the chart sizes in 2007 are measured differently than in previous versions. Has anybody had the same problem ? If so, is there a workaround ? Thanks. MD Jon: How can I base my chart in cell size and not in points ? Also, I am aware about the differences in default fonts, that is why I am initializing everything to Arial 10pt, using the same cell width and so on, but still XL2007 prints differently. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumifs in previous Excel-Versions | Excel Worksheet Functions | |||
Excel 2007 vs previous versions | Excel Discussion (Misc queries) | |||
Chart sizes with window in Excel 2007? | Charts and Charting in Excel | |||
How compatible is Excel 2003 with previous versions | Excel Discussion (Misc queries) | |||
Please include fonts from previous versions ('98) in new versions | Excel Discussion (Misc queries) |