Background:
Hello! I am relatively new to using the more advanced features of excel, and have been staring down this problem for about a day now with multiple failed attempts. I have seen similar problems solved using VBA, but this is not something I have ever done.
I am creating an excel document that management will enter data into daily, and embedded charts will dynamically update. It will keep track of types of problems, their sources,the model being worked on, and who was working that shift. Instead of having multiple charts, they are using the filter feature to only see the information that is most relevant.
Model numbers are alpha-numeric (ES4021E) and there are 107 of them. I defined all of their values and created a drop-down menu to select the appropriate model, and used =VLOOKUP(D2, 'DROP DOWN DATA'!$A$2:$B$108, 2, 0) to assign each model a number so that I could graph it.
The Problem:
While I can chart the number of the model to a particular date, and nest that inside other charts to show what problems occurred on that date and model, I need to be able to label the chart to display the model name and not the number I assigned it. I downloaded the XY Chart Labeling Tool, and could not get it to work for my application.
Constraints:
Whomever is entering in data should be able to select a model, and see it appear on the chart for that day
Solution should avoid VBA if possible
I will need to do something similar with dates employees are working the station as well
I am open to other solutions to the problem
Hello! I am relatively new to using the more advanced features of excel, and have been staring down this problem for about a day now with multiple failed attempts. I have seen similar problems solved using VBA, but this is not something I have ever done.
I am creating an excel document that management will enter data into daily, and embedded charts will dynamically update. It will keep track of types of problems, their sources,the model being worked on, and who was working that shift. Instead of having multiple charts, they are using the filter feature to only see the information that is most relevant.
Model numbers are alpha-numeric (ES4021E) and there are 107 of them. I defined all of their values and created a drop-down menu to select the appropriate model, and used =VLOOKUP(D2, 'DROP DOWN DATA'!$A$2:$B$108, 2, 0) to assign each model a number so that I could graph it.
The Problem:
While I can chart the number of the model to a particular date, and nest that inside other charts to show what problems occurred on that date and model, I need to be able to label the chart to display the model name and not the number I assigned it. I downloaded the XY Chart Labeling Tool, and could not get it to work for my application.
Constraints:
Whomever is entering in data should be able to select a model, and see it appear on the chart for that day
Solution should avoid VBA if possible
I will need to do something similar with dates employees are working the station as well
I am open to other solutions to the problem