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

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

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

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