Auto update chart source reference
 

Using a "Pie Chart" ( I know, boo) with two values. These values are updated
weekly - on same worksheet, next row, same column.

How do I have the chart updated weekly to the current values, other than
reassigning the "source data" link manually?

Auto update chart source reference
 

Like this, only the last row not the last 12:

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"HankW" wrote in message
...
Using a "Pie Chart" ( I know, boo) with two values. These values are
updated
weekly - on same worksheet, next row, same column.

How do I have the chart updated weekly to the current values, other than
reassigning the "source data" link manually?

Auto update chart source reference
 

In article ,
says...
Using a "Pie Chart" ( I know, boo) with two values. These values are updated
weekly - on same worksheet, next row, same column.

How do I have the chart updated weekly to the current values, other than
reassigning the "source data" link manually?

In addition to Jon's suggestion, see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions