Not sure where to start

[semper5]

I am needing a kick start...

I have a chart, product number, and several dates that pertain to each product number.
Its a big chart.

Id like to have a cell, where i can enter the product number. Then, the cells adjacent to that cell would return a few specific dates.
Then, I could delete the product number, enter a new one, and then the same thing would happen.

I'm not sure how to even describe what I am trying to achieve, hence no worksheet attached.

What do I start with?

 

[vletm]

semper5
Make a SAMPLE Excel file, upload it here and show with that ... what are You looking for?

 

[GraH - Guido]

1. First make a manual sub data table of your large data set
2. On that table make the chart you need
3. Then start building the table based on formulae (check google for filter data with formula and a selection drop down) and update data series to be fully dynamic

Have a look/read of the following

Creating a Drop Down Filter to Extract Data Based on Selection

Learn how to create a Drop Down Filter in Excel. When you select an item from the drop down, it extracts the data based on the selection

trumpexcel.com

Dynamic Chart Ranges in Excel - How to & Tutorial

Learn how to make the chart series data dynamic, thus when you add or remove rows the chart gets automatically updated. You can use excel tables or OFFSET formula to do this. Use this tutorial (and downloadable example) know how to do this using Microsoft Excel.

chandoo.org

 

[semper5]

See attached sheet;
In Q17, you would be able to enter the complaint number, and then the data that pertains to the complaint number you entered would highlight a different color.

 

[GraH - Guido]

Hi, could you make a manual example of the chart? Thus for a specific complaint number what you want to see/make obvious on the chart. I don't see/understand it yet.

 

[semper5]

In the cell I have selected 37131, and the blue-highlighted portion is reflective of the complaint number. Had I entered another complaint number, then it would have highlighted the new complaint number entered in similar fashion. does this help?

 

[bosco_yip]

Please followed the above indicated Conditional Formatting formula rules and applied ranges.

Regards
Bosco

 

[GraH - Guido]

Clearly not about making a chart... Referring to the data table...