Chart Data Table - How to select two columns

[Noel S Pamfree]

This probably seems a trivial question but I really can't work it out!

Each day I plot a specific currency rate with the date.

I have two charts on a worksheet. One shows the graph since I started in
2003 and the other just the current year.

When I add data I click on the appropriate graph and a blue rectangle
encloses the currency data and a mauve one the dates.

Here is my problem - on one chart, when I drag the adjoining handles at the
bottom of the table to move it to enclose the new data BOTH rectangles move
together however on the other chart only ONE moves so I have to drag them
separately.

What do I have to do to make them both move simultaneously.

Thanks to anyone who knows.

Noel

Excel 2007

 

[Andy Pope]

Hi,

If you select the chart the bounding area will move both label and data
areas.
If you select the series in the chart then label and data areas will move
independently of each other.

Cheers
Andy

 

[Michael.Tarnowski]

This probably seems a trivial question but I really can't work it out!

Each day I plot a specific currency rate with the date.

I have two charts on a worksheet. One shows the graph since I started in
2003 and the other just the current year.

When I add data I click on the appropriate graph and a blue rectangle
encloses the currency data and a mauve one the dates.

Here is my problem - on one chart, when I drag the adjoining handles at the
bottom of the table to move it to enclose the new data BOTH rectangles move
together however on the other chart only ONE moves so I have to drag them
separately.

What do I have to do to make them both move simultaneously.

Thanks to anyone who knows.

Noel

Excel 2007

Hi Noel,
you can define the data range as a dynamic named range; the benefit of
dynamic ranges is that they expand automatically when new data are
appended. For a tutorial / introduction of dynamic ranges see:
http://www.ozgrid.com/Excel/DynamicRanges.htm
Have fun
Michael