Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart update using button
Hi
How do i update chart using Command Button and VBA I have D10:D500 where i need to plot chart on those values I have "" this on D10:D500 if there is no data on other column E10:E500 , problem is its assuming that its 0 If there is no value on the D column cell and my chart comes back to Zero and a stright line. Is there any way to update chart using command button if only there is Value on D10:D500 ? I have 4 sheets sheet1!D10:D500 , Sheet2D10:D500 all are plotted on the same chart comparing the performance of each work sheet on Chart hope this can be done thank you in advance... Regards Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto update of a chart | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Macro to Update Chart | Charts and Charting in Excel | |||
How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
Automatic Chart Update? | Charts and Charting in Excel |