Chart Data Table - How to select two columns


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
 
Ad

Advertisements

A

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
 
Ad

Advertisements

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top