If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
FAO Andy Pope please...
Hi Andy.
re your polar plot utility. I've tried to contact you recently, but our mail system doesnt seem to like the .info email address. A question if I may. How the "bleeeep" do I get your ploar plot tool to automaticaly update when the source data changes? The only way I can find to make the new data change the plot graph, is to remove and re-do the polar plot. It's been a (very) long time since I had to work in Excel (can't say I'm enjoying it!) I have messed with VBA macro's to the extreeme in the past, but the so called "simple" stuff excapes me at times. Sadly I'm stuck with Excel 2000, we don't have (it seems) licences for anything newer! Tin hat and flame proof suit on, car door open, engine running... Regards. Dave B. |
#2
|
|||
|
|||
FAO Andy Pope please...
Hi,
The addin does not create dynamic formula to the source data. You do not need to re-create the chart just select the chart, click the Polar plot menu and the settings will be reloaded. Press Ok and the values will update. You can also do it by using trigonometry formula to calculate the new xy position based on the Angle and Distance. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Dave Baxter" wrote in message ... Hi Andy. re your polar plot utility. I've tried to contact you recently, but our mail system doesnt seem to like the .info email address. A question if I may. How the "bleeeep" do I get your ploar plot tool to automaticaly update when the source data changes? The only way I can find to make the new data change the plot graph, is to remove and re-do the polar plot. It's been a (very) long time since I had to work in Excel (can't say I'm enjoying it!) I have messed with VBA macro's to the extreeme in the past, but the so called "simple" stuff excapes me at times. Sadly I'm stuck with Excel 2000, we don't have (it seems) licences for anything newer! Tin hat and flame proof suit on, car door open, engine running... Regards. Dave B. |
#3
|
|||
|
|||
FAO Andy Pope please...
|
#5
|
|||
|
|||
FAO Andy Pope please...
|
Thread Tools | |
Display Modes | |
|
|