• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

chart value depends on checkbox checked

smittal

smittal

Member
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.
 

Attachments

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?
 
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
 
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.
 

Attachments

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..
 

Attachments

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 :P


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.
 

Attachments

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.
 

Attachments

You must log in or register to reply here.
Back
Top