A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Seemingly impossible bug with excel charts



 
 
Thread Tools Display Modes
  #1  
Old February 23rd, 2009, 12:42 AM posted to microsoft.public.excel.charting
Lane
external usenet poster
 
Posts: 20
Default 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  
Old February 23rd, 2009, 08:17 AM posted to microsoft.public.excel.charting
Shane Devenshire[_3_]
external usenet poster
 
Posts: 3,333
Default 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  
Old February 23rd, 2009, 08:31 AM posted to microsoft.public.excel.charting
Shane Devenshire[_3_]
external usenet poster
 
Posts: 3,333
Default 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  
Old February 25th, 2009, 01:08 PM posted to microsoft.public.excel.charting
Lane[_2_]
external usenet poster
 
Posts: 1
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.