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
|
|||
|
|||
Seemingly impossible bug with excel charts
I have a mostly working report writer which, in XL 2003 worked fine. we are
migrating our report writer to XL 2007. At first, when calling a print preview from an array in code, the macro would run once, but if i tried to run it a second time, excel would error out saying "out of range" - i found out that after the first run of the code that excel was renaming the chart to "home chart 1"...yeah...so as a workaround, I moved the chart pages into workheets as chart objects. Now, the problem is: When I try to print preview a sheet containing a chart object, and at the same time, i am trying to preview a data sheet, the chart doesn't show up. though it exists in the work view. what is going on here? am i the only person experiencing this? -- - Lane |
#2
|
|||
|
|||
Seemingly impossible bug with excel charts
Hi,
How are your dates entered in the spreadsheet? 1/1/2007 or 7 or 2007 or what? You say they are displaying as 1, 2, ... 27 does this mean there are 27 years of data? Are your dates entered as text? Maybe you are using an XY Scatter Chart when you should use a Line Chart? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Lane" wrote: I have a mostly working report writer which, in XL 2003 worked fine. we are migrating our report writer to XL 2007. At first, when calling a print preview from an array in code, the macro would run once, but if i tried to run it a second time, excel would error out saying "out of range" - i found out that after the first run of the code that excel was renaming the chart to "home chart 1"...yeah...so as a workaround, I moved the chart pages into workheets as chart objects. Now, the problem is: When I try to print preview a sheet containing a chart object, and at the same time, i am trying to preview a data sheet, the chart doesn't show up. though it exists in the work view. what is going on here? am i the only person experiencing this? -- - Lane |
#3
|
|||
|
|||
Seemingly impossible bug with excel charts
Hi,
Maybe you have the data range set as the Print Range? So try choosing Page Layout, Print Area, Clear Print Area. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Lane" wrote: I have a mostly working report writer which, in XL 2003 worked fine. we are migrating our report writer to XL 2007. At first, when calling a print preview from an array in code, the macro would run once, but if i tried to run it a second time, excel would error out saying "out of range" - i found out that after the first run of the code that excel was renaming the chart to "home chart 1"...yeah...so as a workaround, I moved the chart pages into workheets as chart objects. Now, the problem is: When I try to print preview a sheet containing a chart object, and at the same time, i am trying to preview a data sheet, the chart doesn't show up. though it exists in the work view. what is going on here? am i the only person experiencing this? -- - Lane |
#4
|
|||
|
|||
Seemingly impossible bug with excel charts
I'm not sure what the dates have to do with anything, but I'd be willing to
try whatever... my issue currently is on my desktop, when i request a print preview in excel 2007 like so: sheets(array(data1, data2, chart1 (in a worksheet)).printpreview, the chart1 which is an object in a worksheet, doesn't display. sorry if there was confusion... I've tried it with the chart selected/deselected, printarea defined/undefined,big chart/little chart. i'm running low on ideas...and the rub....it works on my laptop...^ have you seen this? thanks, Lane |
Thread Tools | |
Display Modes | |
|
|