M
mathew
Good evening all,
I have created charts using JW's 'Chart From Combo Box' in chapter 15 from his Excel 2000 functions CD.
This has worked great, being able to choose the required chart from the drop-down list, which I have adapted.
However, the 'chart titles' do not change to the appropriate value when I choose the suitable chart, but remain the same
throughout my choices, eg every chart title is called 'March', when in fact I am looking at a chart produced for February.
I have tried naming the title in Options/Chart Title, but still all charts remain with the same title.
This is really bugging me, and have spent hrs trying to figure this out, but to no avail.
Any help help here would be most appreciated, as my reports are for multiple access, and hence cannot post to the server until
fixed.
Cheers,
Mathew
I have created charts using JW's 'Chart From Combo Box' in chapter 15 from his Excel 2000 functions CD.
This has worked great, being able to choose the required chart from the drop-down list, which I have adapted.
However, the 'chart titles' do not change to the appropriate value when I choose the suitable chart, but remain the same
throughout my choices, eg every chart title is called 'March', when in fact I am looking at a chart produced for February.
I have tried naming the title in Options/Chart Title, but still all charts remain with the same title.
This is really bugging me, and have spent hrs trying to figure this out, but to no avail.
Any help help here would be most appreciated, as my reports are for multiple access, and hence cannot post to the server until
fixed.
Cheers,
Mathew