Chart Data Table - How to select two columns

  • Thread starter Thread starter Noel S Pamfree
  • Start date Start date
N

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
 
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
 
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
Click to expand...

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