Update Charts

G

Guest

Is there a quick way to update charts to include another row or column of
data in the source data? I have about 10 different charts that point to data
in a worksheet. Each day, I have to go in and change the source data for
each series in each chart to include an additional row of data.

Thanks,
Mike.
 
M

MartinW

Hi Mike,

You can extend your range down as far as you like, well at least as far as
the 32,000 points limit anyway.

Say your data is in A1:B100,
Set your source range to say A1:B500

That will give you more than a year before you have to reset it.
Empty cells past the end of your data won't affect the chart
until you enter a value in them.

HTH
Martin
 

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

Similar Threads

Automatically shift chart data range 4
Pivot Charts 3
Automatically shift chart data range: redux 6
Excel Charts 2
Cannot update "Chart data range:" Field 2
How to create multiple bar charts at the same time? 0
Pivot Tables/Charts and common filter 1
Multiple Named Range questions 6

Top