Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 105
  • Last Modified:

Dynamic Graph from Dropdown List

Hello. On the IndividualGraph sheet one can view a graph for each student by selecting the name from the dropdown list. I've got the dropdown list and table index working. Any idea why the graph does not plot on the sheet? Thanks
Score.xlsx
0
zerog
Asked:
zerog
1 Solution
 
Rob HensonIT & Database AssistantCommented:
The results in your table are coming through as text so won't show in the graph.

Two options, change the source data to numbers or enclose the INDEX formula within a VALUE() function:

=VALUE(INDEX(DB_Table,DB_Selected_Learner,C$15))

Thanks
Rob H
0
 
zerogAuthor Commented:
Enclosing the INDEX formula within a VALUE() function works perfectly
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now