limited source data allowed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top