chart value depends on checkbox checked

[smittal]

Hello All

i am making a dashboard and need anybody's help to complete the same. in attached file there are two columns B and c, filled with data and pie chart value depends on these column data. for now pie chart is considering entire B & C column for chart data range but i want ...

there is a checkbox in column A for each and every value

if the checkbox is selected (checked), then only chart will consider the value for same else not.

thanks in advance.

 

[NARAYANK991]

Hi Shweta ,

Is this acceptable ?

Narayan

 

[kchiba]

Hi Smittal,

I have put new check controls on your spreadsheet that control what is on the Chart

cheers

kanti

 

[smittal]

Thanks both for your replies.

looking for the same which replied by Narayank sir. but sir there is a question.

1) please suggest how we do it?
2) if we add any check box then, can it done automatically?

 

[NARAYANK991]

Hi Shweta ,

If you go through the worksheet , you can figure it out. A helper column has been added to either use the data value or use NA() , which is not plotted. In order to do this , the LinkedCell property of the checkbox has been used ; the 6 checkboxes have their LinkedCells as L1 , L2 ,..., L5 , L6.

If you add more checkboxes , just configure their LinkedCells to point to worksheet cells , say L7 , L8 ,... , and copy the formula in E9 downwards.

Narayan

 

[smittal]

Dear Narayan Sir,

Thank you so much for your response. i have learned a new property of checkbox.(linked)

can you please clear few more doubts:-

1) ca we linked checkbox with different tab(in same worksheet)
2) it is possible that when we un-select any checkbox then its value will still rremain in chart but as colorless.

So, quite, its sound stupid but if anyone can help to for same.

 

[Debraj]

Hi Shweta,

can you please check this one.. if its working as per your idea..

Can you please check the attache . as (I Think) my check boxes are not updating according to click..

 

[smittal]

Dear Debraj,

Thanks for your reply. but how can i select the checkbox. My Requirment is for dynamic chart based on checkbox selection and de-selection. (value and category have to be visible but colorless in case of de-selection)

Also, i tried to achieve my requirement with a New Idea. I modified my idea, concept and implementation but still stucked


Its really very greatful if someone please suggest me to how we add images in funnel (sheet2). there is a VBA code to sort the data when the sheet gets activate.

 

[smittal]

Dear All,

would request you to please suggest:-

In a dynamic excel pie chart, if we want to show category name with legends on graph, for only those values which are zero.

is it possible? i am very confused here.

Thanks in advance for same.

file attached with dummy data for reference.

 

[sgmpatnaik]

@smittal

i am not sure why you want to display the 0 value in chart but as my knowledge i think it will not display the chart for 0 value

please check attached file in Sheet2