Z
zephyr
Many thanks for your response. I was trying to hide the charts but I have
looked at the example and it is a good solution to my problem.
I have been trying to get the combo box to work on my application. The
example provided has one line on each graph. The graph that I have has six
lines.
The problem that I have is that I cannot get the table source data to link
to the combo box. On the example given the table source data reads:
=’Chart Combo Box’!$A5$A9,’Chart Combo Box’!$E5$E9
In my application the table source data reads:
=’01 Sales’!$I$159: $U$159, ’01 Sales’!$I$166: $U$176
01 Sales is the name of the worksheet, when I put in ’Chart Combo Box’ an
error message pops up. I have inserted the ’Chart Combo Box’ and tried
removing ’01 Sales’ but the error message keeps on popping up. Is there a way
to link the chart to the combo box?
Many thanks
looked at the example and it is a good solution to my problem.
I have been trying to get the combo box to work on my application. The
example provided has one line on each graph. The graph that I have has six
lines.
The problem that I have is that I cannot get the table source data to link
to the combo box. On the example given the table source data reads:
=’Chart Combo Box’!$A5$A9,’Chart Combo Box’!$E5$E9
In my application the table source data reads:
=’01 Sales’!$I$159: $U$159, ’01 Sales’!$I$166: $U$176
01 Sales is the name of the worksheet, when I put in ’Chart Combo Box’ an
error message pops up. I have inserted the ’Chart Combo Box’ and tried
removing ’01 Sales’ but the error message keeps on popping up. Is there a way
to link the chart to the combo box?
Many thanks