Chart Limiting to 10 cells

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Does anyone know why the chart wizard would limit a chart
series range to 10 cells? I have a worksheet that tracks
monthly data for 15 people and I am trying to create
monthly charts to display the data, but when I put in the
cell range, all of the references diappear when I reach
the tenth cell. I have tried from the top of the range,
bottom of the range, and the middle of the range, but each
time I get to ten cells, all of the references disappear.
Any help would be appreciated.

Steve
 
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