marle35
Programmer
- Jul 17, 2007
- 36
I have a problem in that I am unable, at times, to set the property of .ChartTitle.Text of the chart object. I found that this happens when the chart has no data. For instance, a product is chosen that happens to have no data associated with it. So nothing appears in the chart. Then, a different product is selected, and I get "Run-time error '1004': unable to set the text property of the charttitle class." How do I get around this? Is there a way to test for whether there is no data in the chart?
Also, is there a way programatically to set the minimum and maximum X-axis values shown on a chart?
Also, is there a way programatically to set the minimum and maximum X-axis values shown on a chart?
