Updating charts

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I'm trying to update a chart with more data. I choose
'source data', 'series' then 'values' and select the data i
want to add using the ctrl button but i'm not able to
select some of the cells in the worksheet. When i try to
select these cells the 'Source data - values' box empties.

Is anyone able to help with this? It would be greatly
appreciated.
 
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