I have data in an Excel sheet named 'Readiness' cells C12 to C17. I would like to create a chart on a separate sheet using this data. I've provided a sample sheet for reference. Additionally, I want to add a button name is MEV,TA,DTER,HF,W 700,MS to dynamically generate the chart. How can I accomplish this? i attached the sample workbook
As modeled on Sheet2:
1. Put a drop down in cell G3 as opposed to a button
2. Populate cell C19 on the Readiness sheet using: =Sheet2!G3
3. Populate cells D19:BR19 on the Readiness sheet using: =INDEX(D12:D17,MATCH($C19,$C12:$C17,0))
4. Change the source data in the Chart on Sheet2 so that
Series name is: =Sheet2!$G$3
Series values is: =Readines!$D$19:$BR$19
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thanks for your response, Jetemc. Your suggestion is correct. However, I'd like to gather another opinion ALL. When I select "all," I need to receive all data the graph charts. can you help me
When you say all data do you mean that the column above 19 should show 125 or that there should be three columns one of 100, one of 10 and the other of 15 as on Sheet 3?
I need to include an 'ALL' option in the dropdown menu. When 'ALL' is selected, I want to retrieve data from S.no 7 to 13 for columns C12 to C17 in the graph. Could you assist with implementing this feature?
dear please find this attached
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks