Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2003

Tip: Looking for answers? Try searching our database.

limited source data allowed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kevin - 26 Dec 2003 14:41 GMT
When I select the source data, Excel allows only 10 or so rows. Then it beeps when I click on the next row, discards the previously selected rows and starts over. I tried manually entering the problem row and it will not allow me to. I do not get any error messages. It just beeps. Is there something that limits me? The chart was previously made in excel 97 then I upgraded to 2000. I just want to change the source data range.
Debra Dalgleish - 27 Dec 2003 14:20 GMT
There's a limit to the number of characters that you can enter in the
Data Range box.

As a workaround, you could define the range of cells that you want to
use, and enter the range name in the Data Range box. There are some
instructions here for creating a named range:
   http://www.contextures.com/xlNames01.html

Or, create a summary table on the worksheet, linked to the data, and
create the chart from that table. To create a summary table, enter
references to the data in a contiguous range of cells. For example, if
the data for a chart is:

Series1: A5, C5, E5, H5, L5, T5
Series2: A9, C9, E9, H9, L9, T9

You could create the summary table starting in cell V2:

In V2:  =A5
In W2:  =C5

etc., to pull all the data into a contiguous range.
Then, select this range, and create the chart.

> When I select the source data, Excel allows only 10 or so rows. Then it beeps when I click on the next row, discards the previously selected rows and starts over. I tried manually entering the problem row and it will not allow me to. I do not get any error messages. It just beeps. Is there something that limits me? The chart was previously made in excel 97 then I upgraded to 2000. I just want to change the source data range.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.