Source Data in Charts

[KABE]

I have a spreadsheet that I'm using to create a line
chart. It is to show daily efficiencies. I've picked the
new cell each day to add to the chart and it's worked fine
until today. The cells are not in order so I use the CTRL
key to add a new cell each day. Today I went to do that
(there are 17 different charts I'm working with) and when
I selected the cell to add today, it unselected all the
others. Is there a limit to the number of cells I can
pick for a chart? I would think that I could have at
least 30 cells worth of info in my chart? Anybody have
any info or help for me? Of course I need these charts
for my boss ASAP.

 

[Debra Dalgleish]

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.