update chart with combo box

**pedjvak** · 06-12-2013, 12:35 AM

Hi every body

I need your help

could you plz show me how we can have ONE chart with many data source that control by combo box
it means we have for example : 3 sheets with different data in each of its & in 4th sheet we have a chart with one combo box then
if we have choose in combo box a code like April then our chart get data from its sheet which related with code in combo box

thanks in advanced

**Mordred** · 06-12-2013, 12:43 AM

Hi pedjvak, there is no easy solution to this and this may require a lot of programming to be that dynamic. I've done this for a workbook but it took me quite a while to analyse the user requirements and then design, and it required a lot of help from this and another forum. I have two suggestions,
1) use a chart for each sheet to display the contents from each sheet. You can filter the data in each sheet and the chart will display the filtered results
2) Pay for a solution in the Commercial Services forum located here.
If you go with suggestion 1, upload a mock workbook with mock data in it (no sensitive or private data) so that someone can help. I think that's the best advice you'll get for now unless someone else here knows of a quick way to meet your requirements.

**pedjvak** · 06-12-2013, 12:51 AM

I appreciate to you , for attention to my post.

**pedjvak** · 06-12-2013, 02:13 AM

Dear All

I solved partially my problem but the other part of my problem is :

in attached file you can see when we choose the month from combo box , in chart you see we have a curve which show zero value
I want you show me how I can fix it (zero value do not be shown in chart)