+ Reply to Thread
Results 1 to 2 of 2

Chart not plotting new data anymore, source data correct.

  1. 02-27-2008, 08:16 PM #1
    mr2mike
    mr2mike is offline
    Registered User
    Join Date
    11-22-2006
    Posts
    8

    Chart not plotting new data anymore, source data correct.

    So I've got this issue...

    I have a chart for all these data point that go back about a year and some and there's a point for every day of the year. The chart has worked flawless up until recently it doesn't want to keep adding the new values. I've adjusted the x-axis for the date and made sure the source values are included in the chart. Its all there and working. When I click on the chart line, it gives you those random black squares along the line. well, it extends out into the range where line doesn't seem to want to go. So its almost like the chart line has gone from red to invisible. I tried changing colors to activate it but that doesn't work. Just wondering what could be the issue? Am I hitting a maximum?

    Thanks for any advice.
    Reply With QuoteRegister To Reply
  2. 02-29-2008, 07:25 PM #2
    mr2mike
    mr2mike is offline
    Registered User
    Join Date
    11-22-2006
    Posts
    8
    I have been trying to figure this thing out for awhile now. I've re made the sheet and it seems as though what is limiting the item is the Category (X) axis labels: When I try to extend this in to future months, it will cut my source data back to Jan-08. It is really wierd. I know all about not having the source data not in the same range of values for the chart to be created properly and this is not it. I am willing to send the file to you to play and see for yourself just let me know, I really need to get this fixed.

    -Mike

    edit: I seem to have fixed it. I pulled back on how far into the future I had the 'Category (X) axis labels:'. I pulled it back from 300 additional to 100 additional cells. Then it charted the source data I had. From there for interest, I tested out 200 extra cells and it dropped the Jan-08 data off the chart but the Feb-08 data was still there. It was just a blank gap. Changed it back to 100 and the source data re appears on the chart. Go figure?!?
    Last edited by mr2mike; 02-29-2008 at 08:06 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1