Excel 2010 Combo Box/Name Manager/Data Validation Issues

Hi,

I am trying to get the chart on sheet 'B1Graph' to display the data for each particular feature on the sheet 'Data' depending on what I pick from the drop down box in 'B1Graph' Cell L2

I am having trouble getting the graph to automatically update and I can't understand where I'm going wrong in my name manager formulas.

Ideally, the row 'Dimension' would be a fixed line (i.e. for Hole A Dia = 0.451) that line would go across as a constant for all weeks.


Please could somebody see attached and help me understand where I went wrong?

Many Thanks,
Kevin
CNCCalibration.xlsx
kev-griggsAsked:
Who is Participating?
 
helpfinderConnect With a Mentor IT ConsultantCommented:
hi Kevin,
not sure if I get your point, but check the attached excel and tell me

Best Regards
- helpfinder -
Copy-of-CNC.xlsx
0
 
helpfinderIT ConsultantCommented:
hi there,
please check this topic, probably it could solve your need
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_28107317.html
0
 
kev-griggsAuthor Commented:
Hi Helpfinder,

This is actually a previous post of mine, i tried translating the formulas across (successfully on a couple of other spreadsheets) but this one would not work.


Regards,
Kevin
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
helpfinderIT ConsultantCommented:
Sorry, I did not check author :)
check my attached excel, if it is as you want it.
CNC.xlsx
0
 
kev-griggsAuthor Commented:
Hi Helpfinder,

Thank you, very helpful!

The only thing is, when i put data into the other cells and change the data to the 'A4-A36' rather than A4-A6, it doesn't work?

I will eventually need for a 2014 version 52 rows worth of data!


Many Thanks again,
Kevin
0
 
kev-griggsAuthor Commented:
Hi Helpfinder,

Many thanks for your help.


Regards,
Kevin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.