PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting GRAPH ERROR

Reply

GRAPH ERROR

 
Thread Tools Rate Thread
Old 20-09-2003, 04:55 AM   #1
RICK
Guest
 
Posts: n/a
Default GRAPH ERROR


When producing graphs with multiple months the dec 2002
data is plotted with jan 2003 data. this has occured since
upgrading to excell 2002
  Reply With Quote
Old 22-09-2003, 09:41 PM   #2
Tushar Mehta
Guest
 
Posts: n/a
Default Re: GRAPH ERROR

[This followup was posted to microsoft.public.excel.charting and a copy
was sent to the cited author.]

Check what XL is plotting. Click the plotted series. Now, in the
worksheet with the data, check what cells are highlighted. I suspect
you will find that the x-y data are offset by 1.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office


In article <900b01c37f2a$fed34b00$a601280a@phx.gbl>, DULS@PTD.NET
says...
> When producing graphs with multiple months the dec 2002
> data is plotted with jan 2003 data. this has occured since
> upgrading to excell 2002
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off