| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple...Update Text Box in Chart | Charts and Charting in Excel | |||
| Can I create an auto update chart in a template | New Users to Excel | |||
| Change scales from reference cells value for a chart in a separate sheet | Charts and Charting in Excel | |||
| Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
Linear Mode
