LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 77
Default Data Range Question

Hello,

Using Excel 2007.

Had to install a new HD, and ever since then am having all sorts of
"problems".

I have a chart with dates in Col B, and then data in C, D, and E.

If I type in a data range, at the pull-down menu,limited to only where
there are actual values in B, C, D, and E, it plots fine.

But if I insert a data range much bigger, the chart goes crazy; either
blank, or nonsense lines, etc.

I want to pick a much larger data range, even though much of it is
blank, so that when values are actually
put in them, it will plot and update automatically.

Apparently it is happy only when the selected range actually has some data.

It never used to be like this.
Some setting must have changed.

Any idea what might be happening ?

Thanks,
Bob

Thanks,
Bob
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
question regarding external data range EdStevens Excel Programming 5 April 9th 08 09:37 AM
Loop QUESTION to end of data range... mniccole Excel Worksheet Functions 2 December 4th 06 09:25 PM
Loop QUESTION to end of data range... mniccole Excel Worksheet Functions 2 December 4th 06 05:19 PM
Data Range Question. ChuckF Excel Worksheet Functions 3 April 11th 06 07:29 PM
Data Validation Range Question Steph[_3_] Excel Programming 2 December 9th 04 07:59 PM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"